Find out the 3rd highest salary?

Answer Posted / sachin

select distinct(sal) from employee order by sal desc limit 2,1;

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is column? : Sql dba

744


how many tables will create when we create table, what are they? : Sql dba

765


What is the purpose of using pl/sql?

830


how to get help information from the server? : Sql dba

677


How many rows can sqlite handle?

782






How do you delete duplicates in sql query using rowid?

720


Which is better trigger or stored procedure?

689


What is trigger in pl sql?

736


What is procedure function?

710


What kind of join is join?

704


How do you write a subquery?

697


what is a composite primary key ? : Sql dba

782


What are the three pl sql block types?

724


What is microsoft t sql?

678


What are all the different normalizations?

745