need help with query

Hi,

I have a table with composite key: ID1 and ID2 and it also has a
priority field.

I want to get all the information for all records with the minimum
priority group by ID2.  How can I achieve that?

Thanks.

Donna

Post table structures, sample data and the result you want

Madhivanan

specifically when I do the following, I lose id2:

select min(priority) as priority, id1 from table t
group by id1

I want it to return id1, id2, priority where it is the min(priority)
group by id1

Try this

Select T1.id1,T1.id2,T2.priority from tablet T1
inner join (select min(priority) as priority, id1 from table t
group by id1 ) T2 on t1.id=T2.id and t1.id2=T2.id2

Madhivanan