Write query to fetch second maximum salary from employee table.
Answer Posted / ritesh
select max(salary) from emptable where salary < (select max(salary) from emptable);
Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Explain coalesce function?
How to use "while" statements in oracle?
How to add another datafile to a tablespace?
What are the extensions used by oracle reports?
How to loop through data rows in the implicit cursor?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
Is truncate autocommit in oracle?
Explain drop constraint oracle?
What is the usage of merge statement?
How to create a new table by selecting rows from another table?
Why is oracle database so popular?
What are the four Oracle system processes that must always be up and running for the database to be useable?
How to create lov dynamically at runtime & attach to text field?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?