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
- 9712 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
How can you create jdbc statements?
What are the advantages of using jdbc datasource?
How many categories of jdbc drivers are there?
What is jdbc and its types?
What are drivers available?
Is jdbctemplate thread safe?
What happens if connection is not closed in jdbc?
What is a rollback in jdbc?
What is the purpose of the jdbc resultset interface?
Which package is used for jdbc application?
What are the differences between resultset and rowset?
Is uri the same as url?
State the different connection methods used for creating different types of sql.
What is jdbc driver for sql server?
Is jdbc connection secure?
