SELECT ID,NAME,SAL,ROWNUM FROM EMP ORDER BY ID DESC WHERE ROWNUM=2

find out the second highest salary?

Question Posted / shalini

55 Answers
91301 Views
Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
E-Mail Answers

Answer Posted / shalini

SELECT ID,NAME,SAL,ROWNUM
FROM EMP
ORDER BY ID DESC
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

How to create an oracle database manually?

1129

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

2040

How to assign values to data fields in record variables?

1077

What do you mean by merge in oracle and how can we merge two tables?

1095

How do I find the database name in oracle?

1088

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2179

Explain integrity constraint?

1209

does the query needs a hint to access a materialized view?

1905

What is a synonym? What are its various types?

1171

How to count duplicated values in a column in oracle?

1105

How do I spool in oracle?

1063

Describe an oracle table?

1098

How to assign values to variables?

1163

What are the differences between char and varchar2 in oracle?

1246

What is the difference between online and offline backups?

1132