find out the third highest salary?
Answer Posted / siddharth mitra
select *
from (select row_number() over (order by salary asc) as
"ROW_NUM" from emp)
where ROW_NUM = 3;
This only works with oracle 8i and 9i,i.e., row_number is an
analytic function.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I call oracle stored procedures that take no parameters?
What are the various constraints used in oracle?
How to rename an index?
What are the different oracle database objects?
How to create an oracle testing table?
How to grant create session privilege to a user in oracle?
What are the roles of dba?
What are the types of trigger in oracle?
What is coalesce function?
How can we delete duplicate rows in a table?
How to define a data source name (dsn) in odbc manager?
What is a system tablespace and when it is created?
How to upsert (update or insert into a table)?
What are the ways tablespaces can be managed and how do they differ?
Will you be able to store pictures in the database?