Query work in sql server but not in MySql

Question

I want get top 1st row from orders table. The following query works in sql server:

select top 1(OrderID)
from dbo.Orders
order by OrderID desc

But it does not work in MySql - how should it be written for MySql?

M.Ali · Accepted Answer · 2015-03-29 01:12:29Z

1

For MySQL use LIMIT

MySQL

select OrderID
from dbo.Orders
order by OrderID desc 
LIMIT 1;

select top (1) OrderID
from dbo.Orders
order by OrderID desc

answered Mar 29, 2015 at 1:12

M.Ali

69.9k17 gold badges110 silver badges133 bronze badges

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

Enjy · Accepted Answer · 2015-03-29 01:22:10Z

0

SELECT OrderID FROM dbo.Orders
ORDER BY OrderID desc 
LIMIT 1;

answered Mar 29, 2015 at 1:22

Enjy

2551 silver badge7 bronze badges