Find out the 3rd highest salary?
Answer Posted / ajay kumar
SELECT DISTINCT SAL FROM EMP WHERE SAL = (SELECT DISTINCT
SAL FROM EMP X WHERE &N= (SELECT COUNT(DISTINCT SAL) FROM
EMP Y WHERE Y.SAL>X.SAL))
/
AFTER RUNNING THE QUERY PUT THE VALUE OF N
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is java sql connection?
What is execute immediate?
What is trigger and how to use it in sql?
What is sql not null constraint?
How do I use google cloud in sql?
What does sql stand for?
What is auto increment in sql?
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
what is self-join? : Sql dba
how tsql statements can be written and submitted to the database engine? : Transact sql
How many types of keys are there in sql?
How many times can we commit in a loop?
What is before trigger?
Is sql procedural language?
What are views in sql?