select sal from (select distinct(sal) from emp where sal is NOT NULL order

how to find the second highest salary from emp table?

Question Posted / sumit sharma

211 Answers
367444 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 / sumit sharma

select sal from (select distinct(sal) from emp where sal is
NOT NULL order by sal dsc) where rownum = 2

Is This Answer Correct ?

1 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is rowid in sql?

978

What is column?

983

Does postgresql run on the cloud?

1140

What is the usage of nvl function?

1031

what is online transaction processing (oltp)? : Sql dba

992

Can we commit in trigger?

966

What is view? Can we update view

1430

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2109

what is the difference between cluster and non cluster index? : Sql dba

1021

Is mariadb a nosql database?

1042

what is transaction? : Sql dba

1003

What are literals in sql server?

1160

Why is sql*loader direct path so fast?

1099

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2564

Define join and name different types of joins?

1004