This Blog has moved to http://www.falsepositives.com/

False Positives Adventures in Technology, SciFi and Culture from Toronto

Monday, February 02, 2004

More MySQL Crash Course

Nice piece : ONLamp.com: 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 )



Please Note that this Blog (False Positives) has moved to http://www.falsepositives.com/

Links to this post:

Create a Link

<< Home