find the third highest salary?

Answer Posted / anil pednekar

select * from (select sal from table1 group by sal ) where
row num=3

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why are aggregate functions called so?

685


What is query optimization in sql?

727


What is on delete set null?

767


What is data types in sql?

712


table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

3723


What is transaction control language (tcl)?

851


How do you know if a relationship is 2nf?

695


Explain some predefined exceptions.

782


What are sql queries used for?

769


Why do you partition data?

727


what is csv? : Sql dba

764


Explain the update statement in sql

735


How do you exit in sql?

817


how to add a new column to an existing table in mysql? : Sql dba

788


How do I create an index in word?

738