Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 9584 Views
- Bosch, HireCraft, Infosys, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What are the three parts of a jdbc url?
If I use the JDBC API, do I have to use ODBC underneath?
Explain the difference between rowset vs. Resultset in jdbc?
How can we execute stored procedures?
How can I get information about foreign keys used in a table?
Explain what should be done when a SQL exception is raised?
Can I get a null resultset?
How can I get or redirect the log used by DriverManager and JDBC drivers?
What protocol does jdbc use?
Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?
Does jdbc require oracle client?
Explain the process of creating tables using NetBeans IDE?
What are the higher level apis under development on top of jdbc currently?
How can I create a custom RowSetMetaData object from scratch?
What are different types of JDBC Drivers?
