sql query for displaying age from oldest to youngest

Solutions on MaxInterview for sql query for displaying age from oldest to youngest by the best coders in the world

Search
showing results for - "sql query for displaying age from oldest to youngest"
Wendy
20 Jun 2020
1//Oldest to youngest
2SELECT * FROM table_name ORDER BY age DESC;
3
4//Youngest to oldest
5SELECT * FROM table_name ORDER BY age ASC;
similar questions
sql get highest date from 3 tabelsmssql last day of monthsql calculate working days between two dates excluding weekends and holidayscomplete date is 1 year or not sql serverdate 3 months from today sqlhow to find date from date table in sqlcalculate age in sqloracle last day of monthmonthly birthday sql querysql where last 12 monthshow to get all dates in a month in oraclecurrent year sql oracleget records in sql according to month name and countoracle sql day of month from datemysql calculate agesql select upcoming birthdaysoracle sql first day of yearmysql get age from dateget current month last date in sql servercount number of entires by months sqlselect the date 30 days less that the todays date sql requestsql date with yearsql server select furst day of current year
queries leading to this page
how to fina the oldest in age in a table how to find the 2nd youngest employee from date of birth in sqlhow old is the oldest sql queryoldest to newest employee sqlhow i can find youngest age to oldesr in sqlfind age then show youngest age to oldest in sqlsql select oldest and youngestquery for age of 4 most oldest person in sqlresult by age from youngest to oldest sql oraclequery to get highest timestampsyntaxs for sql to get the oldest item by birthdyaysql statement to return state name and year of the oldest statesql query for displaying age from youngest to oldestlist the name and birthday of the oldest and youngest customers in sqlyoungest and oldest age from sql statementhow to find the second youngest employee from date of birth in sqlsql query for displaying age from oldest to youngestsql query for displaying age from oldest to youngest