select sal from emp e where 2= (select count(distntsal) from emp y where e

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / naresh

Answer Posted / naresh

select sal from emp e where 2= (select count(distntsal) from
emp y where e.sal<=y.sal);

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can we use threading in pl/sql?

1036

How can you fetch first 5 characters of the string?

1011

What is sql injection owasp?

1058

What is pl sql block structure?

1034

How can we find duplicate records in a table?

944

What is difference between stored procedure and trigger?

1160

How can you select unique records from a table?

1070

What is cartesian join in sql?

1115

Is sql considered coding?

1043

Explain the difference between rename and alias?

1010

What is a schema? How is it useful in sql servers?

1114

How do I debug a stored procedure?

1109

What is user in sql?

1016

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1145

Write a sql query to find the names of employees that begin with ‘a’?

1008