All SQLite Basic Subquery Statements with example

The following exercise will help you to improve your SQLite query skills effectively. I have used BD Browser for sqlite for following exercise.

  1. Write a query to find the student names, admission fee, whose admission fee is greater than the average admission fee
  2. Write a query to find the full name and fee of the students who have a higher salary than the student whose last_name=’smith’
  3. Write a query to find the 5th maximum admission fee in the student table
  4. Write a query to find the 4th minimum admission fee in the student table
  5. Write a query to select last 5 records from a table
  6. Write a query to get 4 maximum admission fees
  7. Write a query to get 4 minimum admission fees
  8. Write a query to get nth max admission fee of student

 

Leave a Comment

x