Sql

[Nishi]

How do i limit the number of rows selected,
like if i want to select the top three sal takers in the emp table.

[Claymore]

You can achieve this by sticking the LIMIT parameter to your SQL statement. This limits the number of results the SQL statement selects from the table(s) to a number you specificy. In your case, you would need to stick LIMIT 3 to your SQL statement.

In the example you mentioned, where you want to select the top 3 out of the column sal, which is in the table emp, this would result in the following SQL query:

SELECT * from emp ORDER BY sal DESC LIMIT 3;

Please note that I am assuming that the salaries are noted in the table as integers.