find out the second highest salary?
Answer Posted / ishrat ali
select max(salary) from employee where salary<(select max(salary) from employee);
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a cursor variable?
Explain constraining triggers.
What is hash cluster in oracle?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
Explain oracle insert into command?
What is the meaning of recursive hints in oracle?
Please explain drop constraint oracle?
How to get maxsal , minsal, ename department wise in single query
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
What are the restrictions in a oracle read only transaction?
How to shutdown your 10g xe server?
How to create a new table by selecting rows from another table?
Which are the five query types available in oracle?
How to rename a tablespace in oracle?
What is an oracle recycle bin?