More MySQL Crash Course

Nice piece : MySQL Crash Course, Part 3 , basic selects and joins. (a review is always nice).

And I saw something new : The “LIMIT” clause

mysql> SELECT * FROM authors LIMIT 1;

LIMIT (not part of SQL92, DB2 has a FETCH FIRST n ROWS ONLY CLAUSE) would be very useful when you what to find the top 3 Employee salaries (order by Salary Limit 3 ) or the bottom 3 Sales people (order by revenue generate Desending Limit 3 )

Leave a Reply