Tuesday, 17 September 2013

Return name of the employ who having top salary with join

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