find out first highest salary?
Answer Posted / samir kumar sahoo
SELECT DISTINCT salary FROM (SELECT DISTINCT salary,ROWNUM
rn FROM employee ORDER BY salary desc) WHERE rn=1;
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
why dont we assign not null constraint as table level constraint.
What is an oracle database?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What privilege is needed for a user to delete rows from tables in another schema?
What is the max number of columns in an oracle table?
How to bring a tablespace offline?
Explain the use of grant option in exp command.
What is the maximum limit on the number of columns in a table?
What is object data modeling?
How to use subqueries with the exists operator in oracle?
What do you understand by a database object?
Please explain compound trigger in oracle?
How to add a new column to an existing table with a default value?
What is the usage of save points in oracle database?
What privilege is needed for a user to create tables in oracle?