select max(sal) from employeedata where sal

Find out the 3rd highest salary?

Question Posted / ritesh sabanis

Answer Posted / ritesh sabanis

select max(sal) from employeedata where sal <
(select max(sal) from employeedata where sal not in(select
max(sal)from employeedata)) ;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is sql and how does it work?

1171

What are the benefits of stored procedures?

1070

Explain what is table in a database?

1057

what are set operators in sql? : Sql dba

1052

Can two tables have same primary key?

976

Mention what is the use of function "module procedure" in pl/sql?

1049

what is single byte over head in oracle..?

2401

What are the parts of a basic sql query?

967

What is the difference between local and global temporary table?

1045

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1096

How does join work in sql?

1009

What does := mean in pl sql?

1042

Is sql a backend language?

1092

What are the different types of dbms?

1016

Explain what is sql?

1112