How to get the group that has the MAX value for the grouped column

Question

I have a table KIDS that have a Column AGE. I want to use an SQL query to get all the records of the oldest kids.

For example: If I have

Name   Age
----------
David   10 
Dan     10
Leah     8 
Hannah   6

I want to get David's and Dan's records.

Possible duplicate of [SQL select only rows with max value on a column](https://stackoverflow.com/questions/7745609/sql-select-only-rows-with-max-value-on-a-column) — Nick, Feb 05 '19 at 06:37

score 1 · Accepted Answer · answered Feb 05 '19 at 06:33

1

You can try below -

select * from tablename
where age in (select max(age) from tablename)

answered Feb 05 '19 at 06:33

Fahmi

score 0 · Answer 2 · answered Feb 05 '19 at 06:33

0

use max()

  select * from t where age = (select max(age) from t)

answered Feb 05 '19 at 06:33

score 0 · Answer 3 · answered Feb 05 '19 at 14:16

0

You can apply the below code:

select * from old_Records where age =(select max(age) from old_Records)

answered Feb 05 '19 at 14:16

Sahil Anand

3 Answers3