select max(sal) from emp where sal<(select max(sal) from emp where sal

find out the third highest salary?

Question Posted / asadullahrao

Answer Posted / asadullahrao

select max(sal) from emp where sal<(select max(sal) from
emp where sal<(select max(sal) from emp))

Is This Answer Correct ?

1 Yes

6 No

Please Help Members By Posting Answers For Below Questions

Why oracle is used?

1058

How to write date and time literals in oracle?

1002

What is different types of joins?

1022

What is an oracle database?

1035

Explain about integrity constraint?

1122

What are the uses of synonyms?

1138

What is a nvl function? How can it be used?

1031

Difference between inner join vs where ?

1033

How to lock and unlock a user account in oracle?

1106

What are the advantages of oracle 12c?

1180

how do u setup a replication site?

1986

What is the maximum limit on the number of columns in a table?

1086

Compare and contrast between sql and sql server and explain its various functions?

964

What happens if variable names collide with table/column names?

1191

Explain the truncate in oracle?

967