a query to select maxmun 3 salaries of employee table
Answer Posted / krishna kumar r
SELECT E1.ENAME,E1.SAL FROM EMP E1 WHERE 3>(SELECT COUNT(*)
FROM EMP E2 WHERE E2.SAL>E1.SAL ) ORDER BY SAL DESC
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What happens if you lost a data file?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
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?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How to delete a column in an existing table?
Explain what are the characteristics of data files?
Where do we use decode and case statements?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
How do I spool in oracle?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
Explain the use of show option in imp command.
How can I combine multiple rows into a comma-delimited list in oracle?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What is the data type of dual table?
Explain rename?