|
-
Jan 13th, 2010, 09:09 PM
#1
Thread Starter
Member
Findout missed numbers
Dear Experts
Sqlserver Table1holds data as follows
date---------------sno
01/01/2010-------1
01/01/2010-------2
01/01/2010-------4
01/01/2010-------5
01/01/2010-------7
02/01/2010-------1
02/01/2010-------2
02/01/2010-------6
02/01/2010-------8
How to findout missed sno in 01/01/2010?
I want to get this result
3
6
Please help
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote