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
What are the logical operations?
Explain the difference between sap and oracle?
how may join possible between (requisition with purchase order)
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
Explain the truncate in oracle?
What's dateware house and what's clustor with practicle example
State some uses of redo log files?
Difference between inner join vs where ?
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?
What is partitioned table in Oracle?
What are the different types of modules in oracle forms?
What is the string concatenation operator in oracle?
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?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How much memory your 10g xe server is using?