How to get key value of max value in SQL

Viewed 27
tab1(id,sal)
(1,100),(2,200),(3,400),(7,500)

tab2(id,dept)
(1,"HR"),(2,"admin"),(3,"IT"),(4,"CRM")

we have find max salary from this and not to print null

output should be (IT,400)

0 Answers
Related