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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
select a slice of records from a position 1
SQL server vs mySQL ??? 5
Create Procedure gives SQL syntax errors whatever I do 5
SQL Server 2005 throught OLEDB : Named parameter problem ? 3
OdbcCommand exception - MySQL 1
Web Service max out at 20 SQL connections 12
Limiting result set 3

Back
Top