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
- 9503 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
What is JDBC ResultSet?
What is jdbc and its types?
Can I enable requests to a jdbc connection pool for a database connection to wait until a connection is available?
What is jdbc stand for?
What is a jdbc driver and how many jdbc drivers are available?
How do I write Greek ( or other non-ASCII/8859-1 ) characters to a database?
Discuss the significances of jdbc.
How can we retrieve the file in the oracle database?
what happen if we set JDBC string to NULL?
What is connection data?
What is a statement?
What is the difference between ojdbc6 and ojdbc7?
What are types of resultset?
What is xe in oracle jdbc url?
Give an example of code used for setting up connection with a driver.
