In mysql workbench 'select top' is not working... how can i access top 5 in table?

Question

I want to fetch top 5 data from my table.

I try with "TOP" query (Ref by, following link), but it's not working for me.

Click here!

Can some one suggest for this? Thanks in advance.

Answer 1

From the link that you have provided:

SELECT column_name(s)
FROM table_name
WHERE condition
LIMIT number;

SELECT TOP is SqlServer syntax

Answer 2

    SELECT TOP <Number> <column_name(s)> 
    FROM <table_name> 
    WHERE <condition>; 

For this SQL query corresponding MYSQL query is

    SELECT <column_name(s)> 
    FROM <table_name> 
    WHERE <condition>
    LIMIT number;

Using TOP will give the error.