a query to select maxmun 3 salaries of employee table

Answer Posted / chaitanya

Select sal from emp order by desc fetch first 3 rows only;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the logical operations?

669


Explain the difference between sap and oracle?

566


how may join possible between (requisition with purchase order)

1691


From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

579


Explain the truncate in oracle?

539






What's dateware house and what's clustor with practicle example

1629


State some uses of redo log files?

548


Difference between inner join vs where ?

598


What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

516


What is partitioned table in Oracle?

622


What are the different types of modules in oracle forms?

544


What is the string concatenation operator in oracle?

563


Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1496


What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4005


How much memory your 10g xe server is using?

573