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
- 9581 Views
- Bosch, HireCraft, Infosys, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / bln
Select emp.name, emp.id, sal.salary from empDetai emp,
empSal sal
where emp.id=
(select innnerEmp.id from
(select innerEmpSal.id, innerEmpSal.sal from empSal
order innerEmpSal.salary desc
) where rowid=2;
)
And emp.id=sal.id;
This queiry initially execute the inner query and sort
records based on the salary. second inner query returns the
id of second maximum salary.
| Is This Answer Correct ? | 4 Yes | 5 No |
What is execute(), executeUpdate() and executeQuery() methods?
any one can explain about policy file rule? when i connect database with applet then ther is no compile time error but the run time error is occureed.i.e access is denied.policy file rule is related to this problem.
What are the jdbc drivers in java?
Differentiate between type_scroll_insensitive and type_scroll_sensitive.
What is SQL Warning? How to retrieve SQL warnings in the JDBC program?
Where can I find info, frameworks and example source for writing a JDBC driver?
How data can be inserted into long row column of database?
What types of DataSource objects are specified in the Optional Package?
Is there any limitation for no of statments executed with in batchupdate?
How to set the attribute concurrency in resultset?
Explain the life cycle of jdbc.
callable is interface or class ?
Core Java 
