LIMIT 1,10 versus Sql Server: TOP

  • Thread starter Thread starter skneife
  • Start date Start date
S

skneife

I use SQL Server and I need to make some pagination on my web site.

The TOP syntax has not any offset, for example to return 1 to x
records like MySql LIMIT 1, 10 there is no syntax for this.
Does anyone know how to get a range of records like the LIMIT syntax ?

Sam
 
Sam,

Maybe, however this is not a SQL Server while your question is very much
about SQL Server, why don't you ask your question there, here it is the same
as asking what route it is better to go to your job everyday because there
you are using AdoNet.

Cor
 
Back
Top