Interested to Buy Any Domain ? << Click Here >> for more details...
find out the second highest salary?
- 55 Answers
- 89785 Views
- Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
- E-Mail Answers
Answer Posted / souri sengupta
select max(salary) from employee where salary not in (select max(salary) from employee);
This worked :)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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?
What are oracle functions?
How to export your own schema?
How to rename an existing table?
Why should I use oracle database?
How to create a new user account in oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
Can a formula column referred to columns in higher group ?
What is set operator oracle?
why dont we assign not null constraint as table level constraint.
What is primefaces used for?
What is merge in oracle?
WHAT IS ecc 6.0
What is the scope of a local variable?
How to run create database statement again?
