Simple SQL Statement (Hopefully)

[mans]

Hello,

I am attempting to delete a record in a table that contains the minimum numerical value. If the table is called staff and one column contains names and the other the ages, if I wish to delete the youngest person, what statement can I use without creating an additional table.

Thank You

 

[DonPeters]

What database are you using?

Is your age field numerical - if it is you will only be abe to delete ALL records that have that age, unless you have another field that delineates one age from another

 

[DonPeters]

Depending on your database - try:

delete from staff where age = (select min (age) from staff)

or

delete from staff where age = (select minimum(age) from staff)

This will deleta ALL records with the minimum age