Answer Posted / kamala k n
select * from (select ename,sal,rank() over(order by sal desc) as ranks from emp)
where ranks=2;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
20. Using a set operator, display the client number of all clients who have never placed an order.
How to retrieve the count of updated rows?
What is oracle instant client?
How to write date and time interval literals in oracle?
Is there a combination of "like" and "in" in sql?
Difference between oracle's plus (+) notation and ansi join notation?
How to work with data objects interactively?
how may join possible between (requisition with purchase order)
What is oracle rownum?
How to set up autotrace for a user account?
Is oracle a relational database?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
How to create a single index for multiple columns?
can u plz provide me oca sql dumps please i need them
What is a package ? What are the advantages of package ?