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

how to check the 3rd max salary from an employee table?

Question Posted / srinivas

Answer Posted / srinivas

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is drop table faster than truncate?

1052

What is a behavioral trigger?

1027

Explain table and field in sql?

1122

Explain what is a column in a table?

1163

How do you update a value in sql?

1103

What language is oracle sql developer?

1073

Is natural join same as inner join?

987

If a cursor is open, how can we find in a pl/sql block?

1218

Explain the savepoint statement.

1140

What is the difference between stored procedure and view?

1069

What are all ddl commands?

1131

what does the t-sql command ident_current does? : Transact sql

1048

How do we accept inputs from user during runtime?

1120

What are sql functions? Describe in brief different types of sql functions?

1188

What is user in sql?

1079