find out the second highest salary?
Answer Posted / anil
Guys try this to get 2nd highest salary
select max(salary) from employee where salary not in (select
max(salary) from employee)
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is raw datatype?
How to define an anonymous procedure with variables?
What is transport network substrate (tns) in oracle?
How to use subqueries in the from clause in oracle?
Explain what are the characteristics of data files?
In which language oracle has been developed?
What is oracle server autotrace in oracle?
How do I uninstall oracle 11g?
What exactly do quotation marks around the table name do?
what is the difference between data migration and production migration.
Explain constraining triggers.
How to run create database statement again?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
What are the different oracle database objects?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar