'I need remove tra_nr with lower tra_priorytet - SQL query

Please help me! I am sure it is very simple for you. I've tried almost everything with no results.

I need tra_nr with the highest tra_priorytet only.

  select tra_nr, tra_priorytet from AWI_Transporty  where tra_Status = 10  group by tra_nr,TRA_Priorytet   order by TRA_Priorytet desc

sql

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source