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 can we move the cursor in a scrollable result set?
What does adapter class provide?
What is a jdbc connection?
What happens if connection is not closed in jdbc?
what exactly happens when we execute "Class.forname("Driver class name");"?Explain indetail
10 Answers Accenture, HP, IBM, Infosys, SAP Labs, SAS, Sasken, Trigent, Wipro,
Explain the difference between resultset and rowset in jdbc
What is jdbc driver?
Why hibernate is better than jdbc?
What is the meaning of batch updates?
Describe odbc?
How transactions are performed using JDBC ?
How do you determine the sensitivity of the ResultSet object?