SELECT MIN(SAL) FROM (SELECT DISTINCT * FROM EMP ORDER BY DESC) WHERE ROWNU

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

Question Posted / anita prasad

69 Answers
120162 Views
Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
E-Mail Answers

Answer Posted / anita prasad

SELECT MIN(SAL) FROM (SELECT DISTINCT * FROM EMP ORDER BY DESC) WHERE ROWNUM<3;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are %type and %rowtype for?

1108

What are aggregate functions in sql?

1225

What is pl sql block structure?

1095

What are the ddl commands?

1055

Explain unique key in sql.

1063

How do you use collections in procedure to return the resultset?

2286

Can we have two clustered index on a table?

1082

What are some predefined exceptions in pl/sql?

1226

What is full join?

1022

What is cte sql?

1054

What is sql*loader?

1285

What has stored procedures in sql?

1104

what are the limitations of identity column? : Transact sql

1162

What is an oracle stored procedure?

1117

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

1097