Hi there,
I was wondering if sql server has a command to only get an offset of records specified. ie so if you only wanted to return 10 records you could do so..but you can start from the 20th record returned..instead of the 1st
in other sql apps (ie postgresql) you can do select * from table limit 10,20
how do you do it in sql server? (if the command exists)
select top 100 * from table ?
Thanks in advance...
troy
I was wondering if sql server has a command to only get an offset of records specified. ie so if you only wanted to return 10 records you could do so..but you can start from the 20th record returned..instead of the 1st
in other sql apps (ie postgresql) you can do select * from table limit 10,20
how do you do it in sql server? (if the command exists)
select top 100 * from table ?
Thanks in advance...
troy