SQL Get the 10 biggest numbers

Question

I'm trying to retrive the 10 biggest numbers from a table called bonus.

But I'm getting this error message:

Incorrect syntax near 'LIMIT'

My code:

SELECT cust_nr, period1_bonus FROM bonus ORDER BY period1_bonus DESC LIMIT 10

Answer 1

Try this instead:

SELECT TOP 10 cust_nr, period1_bonus FROM bonus ORDER BY period1_bonus DESC

LIMIT <x> is a mySQL construct, not an MSSQL construct. TOP should work for you here.

Answer 2

Try SELECT TOP

SELECT TOP 10 cust_nr, period1_bonus 
FROM bonus 
ORDER BY period1_bonus DESC