Answer Posted / rakhi
SELECT *
FROM (
SELECT employee_id, last_name, salary,
RANK() OVER (ORDER BY salary DESC) EMPRANK
FROM employees)
WHERE emprank = 2;
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
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.
What is a Garbage Collection? and what is full recursive Garbage collection?
Explain how are indexes update?
How to rename an existing table?
What happens if you lost a data file?
Explain alias?
How to update a table row with a record?
List the parts of a database trigger.
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
What is the purpose of save points in oracle database?
Explain what does a control file contain?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
Which is faster join or subquery in oracle?
Is there any function in oracle similar like group_concat of mysql?
How to invoke the data pump import utility?