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
- 9444 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
Why do we need a jdbcrowset like wrapper around resultset?
Which is better odbc or jdbc?
What isolation level is used by the DBMS when inserting, updating and selecting rows from a database?
What class.forname will do while loading drivers of jdbc?
What is batch processing and how to perform batch processing in jdbc?
What is the limitation of PreparedStatement and how to overcome it?
What is jdbc resultsetmetadata interface?
Is jdbc a web technology?
What are the different types of statements in jdbc?
What are different types of ResultSet?
What are JDBC Best Practices?
Does jdbc use odbc?
What are the differences between statement and preparedstatement interface?
What is the use of JDBC DriverManager class?
What is JDBC PreparedStatement?
