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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-31 : 21:32:22
|
MickMan writes "Hi... i was wondering if it is possible to select between rows
in sql server 7.0; something like this is possible->
SELECT TOP 10 *
FROM [dbo].[tablename]
and in mySql you can do something like
SELECT * FROM table
LIMIT 10, 30
where it'll bring out records from the resultset..starting from
row 10 and bringing out 30 records only..
I need a query similar to that in sql server... any help would be greatly appreciated.
Thank you..." |
|
|
|
|
|
Selecting TOP and BETWEEN rows.