Select sal from emp where sal < (select max(sal)from emp) and rownum &l

how to find the second highest salary from emp table?

Question Posted / jigar r gor

Answer Posted / jigar r gor

Select sal from emp where sal < (select max(sal)from emp)
and rownum < 2 order by sal desc

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can delete statement be rollbacked?

984

Define implicit and explicit cursors.

1144

what is sp_pkeys? : Transact sql

1152

What is difference between joins and union?

1122

what is a foreign key ? : Sql dba

1079

What is sql in oracle?

1061

What are the various restrictions imposed on view in terms of dml?

963

What are the types of dbms?

971

Why functions are used in sql?

988

What is pl sql in oracle?

1039

what are the different type of normalization? : Sql dba

1027

What is trigger explain with example?

1033

What is pl sql in dbms?

949

Explain what is a database?

1083

What is sql lookup?

915