sql query to find 3 highest salary with join || MySQL || SQL Server

sql query to find 3 highest salary with join

sql query to find 3 highest salary with join

query :

select top 3 t2.id,t1.name,t1.salary,t2.deptt,t2.desig from tbldesc t1jointbldetails t2 on t1.id =t2.id ORDER BY t1.salary DESC