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
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
How do I find whether a parameter exists in the request object?
Stored procedure purpose?
Explain about the drive manager class working?
How can we execute stored procedures using callablestatement?
What is savepoint in jdbc?
What are the jdbc statements?
Is jdbctemplate thread safe?
How can I create a custom RowSetMetaData object from scratch?
What is the use of getGeneratedKeys() method in Statement?
What are the different types of modifiers?
explain about special characters?
How can I know when I reach the last record in a table, since JDBC doesn't provide an EOF method?