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
How to get a list of all background sessions in the database?
Can we commit inside a function in oracle?
What is a tns file?
what are the advantages of running a database in archive log mode?
How index is implemented in oracle database?
How to connect to a local oracle 10g xe server?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
How to change system global area (sga) in oracle?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
What are the different types of record groups in oracle? Explain each of them
What is concurrency in oracle?
Respected sir, Please send me technical questions related to oracle apps..
List out the components of logical database structure of oracle database.