List The Oldest Record In Sql

We will write some example about oldest and youngest records in sql query. To find oldest record we must sort list by a date column and list the top record. Or we can use sub query.

TO DOWNLOAD THE SAMPLE LİBRARY DATABASE CLICK

Example1: List the oldest student

or with Subquery

Result:

Example2:List the most recently taken book.

or with Subquery

Result:

 

 

YOU MAY WANT TO SEE OUR ALL EXAMPLES PAGE, THEN CLICK HERE

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: