write a query to select name from one table which has id,name and salary from

write a query to select name from one table which has
id,name and salary from another table which has id, sal
where the salary is the second maximum

Question Posted / anonymus

3 Answers
8168 Views
Bosch, HireCraft, Infosys, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

write a query to select name from one table which has id,name and salary from another table which ..

Answer / raveendra reddy

select emp.name,emp.id,sal.salary from empDetail emp,empSal
sal where sal.salary < (select max(salary) from empSal) and
emp.id=sal.id order by desc limit 1;

Is This Answer Correct ?

10 Yes

1 No

write a query to select name from one table which has id,name and salary from another table which ..

Answer / nagendra kumar m r

select top 1 e.[id],e.[name],s.salary from emp e join
emp_sal s on e.[id] = s.[id] and e.[id] in (select top 2
[id] from emp_sal order by salary desc)

Is This Answer Correct ?

1 Yes

1 No

write a query to select name from one table which has id,name and salary from another table which ..

Answer / bln

Select emp.name, emp.id, sal.salary from empDetai emp,
empSal sal
where emp.id=
(select innnerEmp.id from
(select innerEmpSal.id, innerEmpSal.sal from empSal
order innerEmpSal.salary desc

) where rowid=2;

)
And emp.id=sal.id;

This queiry initially execute the inner query and sort
records based on the salary. second inner query returns the
id of second maximum salary.

Is This Answer Correct ?

4 Yes

5 No

Post New Answer