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

What is the difference between instead of trigger and after trigger?

1020

Can we use distinct and group by together?

1068

Which operator is used in query for pattern matching?

1098

What do you understand by case manipulation functions?

1046

Can %notfound return null after a fetch?

1071

How do you create a db file?

1022

What are different methods to trace the pl/sql code?

1132

What does t sql mean?

955

How to know the last executed procedure?

1108

Can we write ddl statements in functions?

1127

What is an exception in pl/sql?

1102

explain commit and rollback in mysql : sql dba

1029

Is pl sql different from sql?

1010

Can we use rowid as primary key?

996

Is grant a ddl statement?

906