select max(sal)from table name where sal<(select max sal from table na

how to find the second highest salary from emp table?

Question Posted / chandu

Answer Posted / chandu

select max(sal)from table name where sal<(select max sal
from table name)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain what is a field in a database and record in a database?

1014

What is a .db file?

925

What is the purpose of primary key?

965

Does inner join remove duplicates?

884

What is sql server and ase?

971

What are some predefined exceptions in pl/sql?

1056

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

925

What is pl/sql language case sensitive?

1058

How many unique keys can a table have?

955

what is 'trigger' in sql? : Sql dba

1008

How do I start pl sql?

892

How do I run a sql script?

1051

What is the order of sql select?

984

Determine if oracle date is on a weekend?

980

Explain exception handling in pl/sql?

987