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 linq to sql?

1139

What are the events on which a database trigger can be based?

1194

explain about mysql and its features. : Sql dba

1021

what is the difference between a local and a global temporary table? : Sql dba

1076

Explain the difference in execution of triggers and stored procedures?

1024

Explain what is a column in a table?

1113

How do I write a cron which will run a sql query and mail the results to agroup?

988

How do you delete duplicates in sql query using rowid?

950

What is sql partition function?

1217

How to connect a sql*plus session to an oracle server?

1134

What is a unique constraint?

1081

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1133

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1151

Is primary key an index?

998

Can we use delete in merge statement?

1043