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
Difference between pre-select and pre-query
Explain the use of inctype option in exp command.
What is pragma autonomous transaction in oracle?
Explain oracle’s server parameter file.
How to loop through data rows in the implicit cursor?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
How do I learn what codesets are available in oracle?
How many types of tables supported by oracle?
what are bitmap indexes? How does they work?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How much memory your 10g xe server is using?
Can a parameter be passed to a cursor?
What are the different types of record groups in oracle? Explain each of them
What are the different types of synonyms?
Define oracle database