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 / balindra sahani

Answer Posted / balindra sahani

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

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the types of database model?

1097

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

1012

I have a few records all are same structures data, I want to store data in multiple targets how

2657

How is data stored in dbms?

958

Explain about query and reporting.

2090

Write the fastest query to find out how many rows exist in a table?

1119

Explain about the relational database?

1074

What is a database development?

966

How would you design a database for an online site, which would average a million hits a day?

1013

How to read and create .LDC data files which are used by linguatic dictionary.

2531

How long can an error message be in raiseerror function?

1002

Explain about normal forms?

1058

Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?

2429

What is normalization? Explain different levels of normalization?

63113

What is data modeling with example?

1000