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
- 9577 Views
- Bosch, HireCraft, Infosys, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Is odbc an api?
What is the JDBC?
What do you mean by odbc?
What is correlated subquery?
Is jdbc connection secure?
How do you determine the sensitivity of the ResultSet object?
Why is jdbc used?
What is the function of drivermanager class?
Is it possible to connect to multiple databases simultaneously?
How to update a resultset programmatically?
How do I find jdbc version?
What is java soft framework?
Give steps to connect to the db using jdbc?
What are the different types of lockings in jdbc?
What are the benefits of PreparedStatement over Statement?
