Return name of the employ who having top salary with join
here is situation . i have two tables , one is table Tbl_employ , second
is tbl_details .
Tbl_employ
id name
1 Ravi
2 ram
3 sham
4 john
Tbl_details
id salary emp_id
1 500 1
2 200 2
3 400 3
4 501 4
I wanna return the name of the employ who having top salary in tbl_detail .
What will be the join query for this condition . Please somebody give some
suggestion .I need it.
Thanks in advance ..
No comments:
Post a Comment