select name, sal from (select name,sal from emp where sal<(select max(sa

how to calcuate the second highest salary of he employee

Question Posted / lalit

Answer Posted / lalit

select name, sal from (select name,sal from emp where sal<(select max(sal) from emp) order by sal desc)where rownum=1;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is output spooling in sql*plus?

1020

What is difference between sql function and stored procedure?

989

What is delete command in sql?

1089

what is rollback? : Sql dba

1081

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

960

What are commit, rollback, and savepoint?

966

What is a primary key sql?

1033

What is the use of triggers?

1022

What is primary key and foreign key with example?

916

What are the benefits of stored procedures?

1047

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1195

What is sql in oracle?

1044

What are character functions?

1073

What is the difference between local and global temporary table?

1025

What is the left table in sql?

952