how to check the 3rd max salary from an employee table?
- 23 Answers
- 33838 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / dulal
Without Using MAX or MIN keyword
select TOP 1 EmpName, RevisedMinutes
from tblEncounter
where RevisedMinutes IN(select distinct Top 3
RevisedMinutes from tblEncounter order by RevisedMinutes
desc)
order by RevisedMinutes asc
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Can you skip header records while loading? : aql loader
Explain commit, rollback and savepoint.
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
who introduced sql?
What are three advantages to using sql?
What is pl sql block in dbms?
What are types of indexes in sql?
What is a mutating table and a constraining table?
How exception is different from error?
What does a pl/sql package consist of?
what is an alias command? : Sql dba
what is the difference between delete and truncate commands? : Sql dba
How do you modify a column in sql?
Is postgresql a server?
Does oracle use sql?
