Skip to content
Advertisement

Delete the row with the highest date difference

I have a table

with values

I would like to delete the row with the oldest student.

I am able to get the ages with the following command but somehow I cant combine it with the DELETE stament

I am using SQL lite

Advertisement

Answer

This would remove the first of the MAX result if there are some with the same age:

This would remove all with the MAX age:

User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement