select * from emp where max(sal) where rownow=2

how to get second highest salary in SQL(as/4000

Question Posted / praveen

Answer Posted / praveen

select * from emp where max(sal)
where rownow=2

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

what are the limitations of identity column? : Transact sql

1047

What is sql mysql pl sql oracle?

1026

Why do we use %rowtype & %type in plsql?

992

How can you select unique records from a table?

992

Could you please provide oca (oracle 10g) dumps for my certification ?

5070

What are the different types of database management systems?

949

What is localdb mssqllocaldb?

1017

What is indexing in sql and its types?

1004

What is the difference between left outer join and left join?

943

What is autocommit sql?

923

How to test for null values?

983

What is the use of nvl function?

1124

What is difference between pls_integer and integer?

908

What are its different types of dbms?

955

How do you delete a table?

997