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 |
|
rcaers
Starting Member
1 Post |
 Posted - 2002-08-01 : 06:48:14
|
| How can I select row 6 to row 10 from my table "TEST".I deleted some rows thats the reason why I cant work with the Id.Please help me,Greetz Ruud |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-08-01 : 08:47:24
|
You are going to need to post the ddl of 'TEST' and maybe some sample data.I would think 'delete select <col_list> from test where [id] between 6 and 10' would do it, but it sounds like that's not working for you...Jay White{0}Edited by - Page47 on 08/02/2002 08:37:10 |
 |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-08-01 : 09:01:25
|
| Check this Article. it might help you Whats afer Topbtw, Jay just visited your site www.setbasedsystems.com . the Profile looks pretty cool.so you and setbased.... work together or both the id's belong to one person???-------------------------What lies behind you and what lies ahead of you are small matters compared to what lies within you.-Ralph Waldo Emerson |
|
|
|
Tiwari
Starting Member
18 Posts |
Posted - 2002-08-02 : 04:11:53
|
| use the query belowselect top 5 * from Test where PK is not in(select top 5 PK from Test)where PK is the primary key of ur table.Edited by - tiwari on 08/02/2002 05:11:01 |
|
|
|
|
|
|
I want to select row 6 to row 10