SQL brain dead ?

[DimPrawn]

table
cols
id_num group num
902 738
456 738
012 738
921 602
223 602
114 559
948 559
335 559

want to pick ONE row in EACH group_num (there are 250 groups)

so only 902, 921, 114

in one query

how? sorry gone brain -

select 902, 921, 114

HTH

[MikeC1408]

select 902, 921, 114

HTH

[bored]

select 902, 921, 114

HTH

at least get it right

select * where id_num in (902, 921, 114)