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
- 9601 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 use of callablestatement? Name the method, which is used to prepare a callablestatement.
What do you mean by database connection pooling?
How can I connect mysql or oracle with java?
java based application for hospital management
What is the fastest type of JDBC driver?
Why is odbc needed?
What is meant by dao?
Why we use while rs next ())?
How many types of jdbc drivers are there?
Explain how to make updates to the updatable resultsets.
What are collection pools?
What are the different types of locking in JDBC?
What is the advantage of namedparameterjdbctemplate?
What are the new features added to JDBC 4.0?
What isolation level is used by the DBMS when inserting, updating and selecting rows from a database?
