SQL Get 10 Biggest Numbers

Question

I am trying to extract the 10 largest numbers from a table called a bonus.

But I get this error message:

Incorrect syntax near 'LIMIT' 

My code is:

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

Answer 1

Since this question is also noted by w / C #, I assume that you are also interested in doing it in C #. Here is the linq-to-sql equivalent of SQL code.

 public IEnumerable<Bonus> GetHighestValues() { var query = (from b in _context.bonus take 10 orderby b.period1_bonus descending select b); return query; } 

Edit - I see that the C # tag is now removed from the question. However, my answer may help you (or others).

Answer 2

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 3

Try SELECT TOP

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

Answer 4

I'm not sure, but it will be

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

work?

Edit: lol, I think I was right (now, seeing other answers all of a sudden) +1 for @Martin for rdbms request :)

Answer 5

You seem to be using SQL Server .

In TSQL syntax is:

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