select sal from emp where rownum=2 order by sal desc

how to find the second highest salary from emp table?

Question Posted / sarojkant

211 Answers
373298 Views
CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
E-Mail Answers

Answer Posted / sarojkant

select sal from emp
where rownum=2
order by sal desc

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how to drop an existing table in mysql? : Sql dba

1093

What is execution plan in sql?

1092

What is nosql db?

1021

How can you know that statistics should be updated?

1129

Why do we create stored procedures & functions in pl/sql and how are they different?

995

Compare sql & pl/sql

1211

What is the difference between view and stored procedure?

1003

How do I create a memory optimized filegroup?

1012

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2556

What is integrity in sql?

1107

how do you control the max size of a heap table? : Sql dba

1027

Can there be more than one function with a similar name in a pl/sql block?

1045

How can I speed up sql query?

1008

what is the difference between undefined value and null value? : Sql dba

1148

What are the different dml commands in sql?

1249