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 / venkat

Answer Posted / venkat

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

Is This Answer Correct ?

19 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What is exit statement?

956

What are inner and outer joins examples of both?

878

What information is needed to connect sql*plus an oracle server?

977

Why do we use cursors?

918

How do I write a cron which will run a sql query and mail the results to agroup?

911

Is postgresql a nosql database?

1073

What is the command used to fetch first 5 characters of the string?

1333

Why use truncate instead of delete?

959

What does trigger mean in psychology?

912

Which sql most popular?

934

What is natural join in sql?

916

How do I run a sql trace?

905

what is the different between now() and current_date()? : Sql dba

933

What is the use of <> sql?

930

When do we use triggers?

1025