find out the second highest salary?
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 is bind variable in oracle 11g?
How to run the anonymous block again?
What is logical backup in oracle?
List the various oracle database objects?
How do I escape a reserved word in oracle?
Can we write dml statement in function in oracle?
what is insert all statement in sql
How to get execution statistics reports on query statements?
What is save point in oracle database?
What do you mean by merge in oracle and how can you merge two tables?
Explain about achiever in sql?
How to create id with auto_increment on oracle?
How to define an anonymous block?
What operating systems are supported by oracle database 10g xe?
Explain oracle data types with examples?