find out the second highest salary?
- 55 Answers
- 81378 Views
- Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
- E-Mail Answers
Answer Posted / kamal
step 1=write a query for maximum salary.
step 2=make a sub query of step 1
step 2 a)let X==sleect all row from your table(employee)
b)let Y=select maximum salary from employee
NOw c)wrie X-Y
Syntax is:
select MAX(salary) from employeee((select * from
employee)-(selcect MAX(salary) from employee))
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the advantages of oracle?
How to export several tables together?
What is Library Cache in Oracle?
What is a procedure in oracle?
Explain about functional dependency and its relation with table design?
Can we insert data in view oracle?
What is oracle host variable?
what are the advantages of running a database in archive log mode?
What is a trace file and how is it created in oracle?
What is partitioned table in Oracle?
How to assign values to variables?
how to do daily transactions with out sql* loader control file regesterd in apps?
How to do paging with oracle?
How to delete an existing row from a table in oracle?
How do I recompile a procedure in oracle?
