Find out the 3rd highest salary?
Answer Posted / karna
Hi Friends,
to get the nth highest value of a column in a table,please
use the below simple query
select min(column) from table where column in(select top n
column from table)
any queries,mail me at karun84@gmail.com
Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
Could you please provide oca (oracle 10g) dumps for my certification ?
How can we store rows in PL/SQL using array?
What is the use of stored procedures?
I need a function for a train ticket reservation please answer it thanks in advance
What do you mean by dbms? What are its different types?
How do you respond to dementia behavior?
What are the types of keys?
What is dcl in sql?
What are the sql versions?
How to set up sql*plus output format in oracle?
How do I tune a sql query?
What is foreign key sql?
Can we create view in stored procedure?
What is a join query?
What is dml and ddl?