Page 25: ORDER BY

SELECT title, category
FROM movie_table
WHERE
title LIKE 'A%'
AND 
category = 'family'
ORDER BY title;

SELECT title, purchased
FROM movie_table
ORDER BY title ASC, purchased DESC;

< Previous Page

Next Page >

Contact the Webmaster | Get the Newsletter

(C) 2008, O'Reilly Media, Inc. | (707) 827-7000 / (800) 998-9938

All trademarks and registered trademarks appearing on HeadFirstLabs.com are the property of their respective owners.