//Oldest to youngest SELECT * FROM table_name ORDER BY age DESC; //Youngest to oldest SELECT * FROM table_name ORDER BY age ASC;