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
- 8235 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
What is the function of setautocommit?
What is db client?
What is @entity in java?
Give an example for execution of sql statement.
What do you mean by database connection pooling?
What are the different types of statements? How we can you use preparedstatement.
What is an advantage of using the jdbc connection pool?
Why do we need jdbc?
How to check jdbc driver version in sql server?
Explain the difference between resultset and rowset in jdbc
How does jdbc connect to database?
How do I stop nullpointerexception?
What is dburl?
When does the result for an sql statement return null?
What is jdbc oracle thin?
