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
What is dual table oracle?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
Explain about achiever in sql?
How to list all tables in your schema?
Can group functions be used in the order by clause in oracle?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
How to change system global area (sga) in oracle?
What is the difference between hot backup and cold backup in oracle?
What is columnar storage what is the advantage?
How would you go about verifying the network name that the local_listener is currently using?
what are bitmap indexes? How does they work?
How do we represent comments in oracle?
How to apply filtering criteria at group level in oracle?
Explain the characteristics of oracle dba?
