Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / nripesh agarwal
select * from emp where salary=(select salary from emp
order by salary desc N,1);
// Put the value for N as for Nth highest salary
// e.g. for 2nd put N=2 , for 3rd put N=3 and so on...
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is type and rowtype in pl sql?
what are the advantages and disadvantages of views in a database? : Sql dba
What trigger means?
How to set up sql*plus output format in oracle?
How do I tune a sql query?
Can we insert data in view?
What are sql indexes?
What is the syntax and use of the coalesce function?
What is the use of function "module procedure" in pl/sql?
which types of join is used in sql widely? : Sql dba
how to get a list of indexes of an existing table? : Sql dba
What is sql query optimization?
what is sql server agent? : Sql dba
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
Is natural join and inner join same?
