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?

You need to specify an order criteria. There is a primary key/unique index/unique constraint on this table ? — Bogdan Sahlean
– Bogdan Sahlean, Commented Aug 7, 2013 at 6:47

Pandiyan Cool · Accepted Answer · 2013-08-07 06:38:17Z

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 7, 2013 at 6:38

Pandiyan Cool

6,5838 gold badges53 silver badges90 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ravi Singh · Accepted Answer · 2013-08-07 06:42:14Z

1

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

answered Aug 7, 2013 at 6:42

Ravi Singh

2,08013 silver badges29 bronze badges

Community · Accepted Answer · 2017-05-23 12:16:42Z

0

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

CommunityBot

11 silver badge

answered Aug 7, 2013 at 6:37

Antoniossss

32.7k7 gold badges67 silver badges119 bronze badges