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
- 9506 Views
- Bosch, HireCraft, Infosys, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How do you determine the sensitivity of the ResultSet object?
If I use the JDBC API, do I have to use ODBC underneath?
Is odbc an api?
What are types of resultset?
State the different connection methods used for creating different types of sql.
What is odbc and jdbc in dbms?
What is jdbc servlet?
What is two-phase commit in the database?
Which jdbc driver type s is are the jdbc odbc bridge?
Is jdbc part of j2ee?
Explain the locking system in jdbc?
What should be done for auto generating primary key id in a table ?
What is serialization and deserialization in java programming?
State the three different ways in which you can create a table?
What are different types of ResultSet?
