Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
asifbhura
Posting Yak Master
165 Posts |
 Posted - 2006-07-20 : 01:58:28
|
| DearI have more than 100 records in my tableI have fetched top 10 records.its okbut i want all records from my table excluding top 10 records.Please help me.regards,ASIF |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-07-20 : 02:03:49
|
| Somthing like this Select * From <YourTable> Where <PK> Not in (Select Top 10 <PK> From <Your TAble> )Chirag |
 |
|
|
|
|
|
i want all rows excluding...