How to convert mysql query into SQL Server query?

Question

How to covert mysql query into mssql query?

SELECT name FROM user LIMIT 5, 10

I have known that mssql don't support 'limit'...

But I have to use limit!

How to covert mysql query into SQL Server query?

http://stackoverflow.com/questions/603724/how-to-implement-limit-with-microsoft-sql-server — galchen, Aug 07 '13 at 06:35
You need to specify an order criteria. There is a primary key/unique index/unique constraint on this table ? — Bogdan Sahlean, Aug 07 '13 at 06:47

score 2 · Answer 1 · answered Aug 07 '13 at 06:38

2

Try out this

SELECT * FROM ( 
  SELECT *, ROW_NUMBER() OVER (ORDER BY name) as row FROM sys.databases 
 ) a WHERE a.row > 5 and a.row <= 10

You can achieve your concept.

answered Aug 07 '13 at 06:38

Pandiyan Cool

score 1 · Accepted Answer · answered Aug 07 '13 at 06:42

1

select * from 
(select name , ROW_NUMBER() over(order by name) rn from user ) a
where rn > 5 and rn<= 15

answered Aug 07 '13 at 06:42

Ravi Singh

score 0 · Answer 3 · edited May 23 '17 at 12:16

0

There is no way to translate this, but there is a bit of workaround here on SO. Check this out.

edited May 23 '17 at 12:16

Community

answered Aug 07 '13 at 06:37

Antoniossss

3 Answers3