• Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

SQL brain dead ?

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
 

Advertisers

Back
Top