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


Please Help Members By Posting Answers For Below Questions

Difference between pre-select and pre-query

550


Explain the use of inctype option in exp command.

569


What is pragma autonomous transaction in oracle?

495


Explain oracle’s server parameter file.

552


How to loop through data rows in the implicit cursor?

517






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.

1340


How do I learn what codesets are available in oracle?

550


How many types of tables supported by oracle?

553


what are bitmap indexes? How does they work?

1697


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?

1498


How much memory your 10g xe server is using?

560


Can a parameter be passed to a cursor?

577


What are the different types of record groups in oracle? Explain each of them

573


What are the different types of synonyms?

564


Define oracle database

578