Interested to Buy Any Domain ? << Click Here >> for more details...
i want to know about mr.b.kotravel......who has answered
for second maxmium salary from employee table
- 3 Answers
- 5974 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mohan
select max(sal) from emp where sal<(select max(sal) from
emp)
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / surya
select * from emp where 2-1=(Select count(distinct(sal)
from emp e where emp.sal<e.sal and ename='mr.b.travel)
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / obulesu
select * from (select e.*,dense_rank() over(order by sal desc) r from emp e) where r=2;
| Is This Answer Correct ? | 0 Yes | 0 No |
If server is in US and client is in india there is timezone is diffrence, How can we display date in indian time when data is displayed from US server timezone?
Is postgres faster than oracle?
How to define a record variable to store a table row?
candidate key is subset of super key but not vice-verse explain
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
How to rename a tablespace in oracle?
What is raw datatype in oracle?
how to delete all duplicate records from a table using subquery?
What are advantages fo Stored Procedures?
Explain the use of record option in exp command.
What is the difference between post-database commit and post-form commit?
Give the different types of rollback segments.
Oracle General 
