Matthew Perkovic thinks this is interesting: Using a combination of ORDER BY and LIMIT, it is possible to find the highest or lowest value in a column. The following example demonstrates how to find the value of the most expensive item:• InputSELECT prod_price FROM products ORDER BY prod_price DESC LIMIT 1;• Output From 5. Sorting Retrieved Data from MySQL® Crash Course by Ben Forta Publisher: Sams Released: December 2005 Note How to find the highest or lowest value? Share this highlight http://www.safaribooksonline.com/a/mysql-crash-course/42766/ Twitter Facebook Google Plus Email Get Instant Access Now Start a Free Trial Have an account? Sign in. Minimise Unlock the rest of MySQL® Crash Course and 30,000 other books and videos By clicking this box, you confirm that you have read and agree to the terms and conditions of our Membership Agreement, and you understand that when your trial period ends, you will be required to provide billing information if you wish to continue using the service. Unlock the rest of this book Start a Free 10-Day Trial loading Learn about Safari for Business Have an account? Sign in.