select max(sal) from emp where sal<(select max(sal) from emp);

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

Question Posted / malli

Answer Posted / malli

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can we join 3 tables in sql?

1108

What do you understand by case manipulation functions?

1081

define join and explain different type of joins? : Sql dba

1002

What does the argument [or replace] do?

1129

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1210

How to connect a sql*plus session to an oracle server?

1176

What is trigger in flip flop?

1063

When is a declare statement required?

1197

What is memory optimized table?

1086

Is t sql a programming language?

1114

What is a dirty read sql?

1247

What is PL/SQL Records?

1256

What are sql triggers used for?

1035

How subquery works in sql?

1131

How does a trigger work?

1146