find out the second highest salary?

Answer Posted / tejinder

select salary from emp order by salary desc limit 0,1;

Is This Answer Correct ?    0 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to get a list of all background sessions in the database?

626


Can we commit inside a function in oracle?

646


What is a tns file?

579


what are the advantages of running a database in archive log mode?

1811


How index is implemented in oracle database?

678






How to connect to a local oracle 10g xe server?

627


Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

689


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

1649


How to change system global area (sga) in oracle?

667


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1757


How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

631


What are the different types of record groups in oracle? Explain each of them

681


What is concurrency in oracle?

635


Respected sir, Please send me technical questions related to oracle apps..

1459


List out the components of logical database structure of oracle database.

663