SQL SELECT TOP statement not working

Question

I am trying to view the first 2 records of a table name Customers which have two columns name Name(varchar) and Salary(text) in MySQL server 6.0
Command which I am using is:

SELECT TOP 2 * FROM customers;

But its not working. Can anyone help me.

Answer 1

I recommend you to write statement like this using LIMIT

SELECT * FROM customers [WHERE conditions] [ORDER BY expression [ASC|DESC]] LIMIT 2 ;

Instead of

SELECT TOP 2 * FROM customers;

Answer 2

It's very simple. Just try this

SELECT * FROM customers LIMIT 2; 

You can check the manual also.