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)
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)