0

Can anyone tell me what is wrong with this query? It's printing the else statement, and it's giving the error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2 * FROM `sql_tbl`' at line 1.

SELECT TOP 2 * FROM `sql_tbl`
Dharman
  • 26,923
  • 21
  • 73
  • 125
Mashhood Ali
  • 127
  • 6

1 Answers1

6

The equivalent "TOP" syntax in MySQL is "LIMIT":

So:

SELECT TOP 2 * FROM `sql_tbl`

becomes:

SELECT * FROM `sql_tbl` LIMIT 2
Dharman
  • 26,923
  • 21
  • 73
  • 125
Reisclef
  • 1,996
  • 1
  • 25
  • 24