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
  • 30,962
  • 25
  • 85
  • 135
Mashhood Ali
  • 127
  • 7

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
  • 30,962
  • 25
  • 85
  • 135
Reisclef
  • 2,056
  • 1
  • 22
  • 25