Select Max(sal) from emp where sal not in (select max(sal) from emp)

Given an employee table, how would you find out the second
highest salary?

Question Posted / mithilesh mishra

Answer Posted / mithilesh mishra

Select Max(sal) from emp where sal not in (select max(sal)
from emp)

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the key features of dbms?

941

Explain what a database is?

978

What is normalization? Explain different levels of normalization?

62697

In which table collections errors are stored.

2338

What are the three basic rules which are to be followed for the relational model of the database?

930

Explain about the storage and physical database design?

865

What is the physical representation for a many-to-many relationship?

1010

How you can make a parameterized view?

953

What is an application role and explain a scenario when you would use one?

949

What is a database development?

901

How to generate OIDS

2168

Explain about relational database management systems?

914

How to combine two function together?

2059

Explain about post-relational databases?

953

How can you log an error to the server event log from a stored procedure?

1029