Query to get max and second max in oracle in one query ?
Answer Posted / naveen
select sal from employee where sal >= (select max(sal) from
employee where sal not in (select max(sal) from employee))
| Is This Answer Correct ? | 7 Yes | 14 No |
Post New Answer View All Answers
What is translate in oracle?
How many types of tables supported by oracle?
How translate command is different from replace?
What is blob data type in oracle?
State all possible different index configurations a table can possibly have?
What is integrity and what is constraint??Explain with example
What is dynamic proxy?
Can we convert a date to char in oracle and if so, what would be the syntax?
What is the difference between hot backup and cold backup in oracle?
Explain the use of show option in imp command.
What do you understand by a database object? Can you list a few of them?
What is the quickest way to export a table to a flat file?
How to add a new column to an existing table in oracle?
What privilege is needed for a user to connect to oracle server?
Is oracle an operator?