find out the third highest salary?
Answer Posted / kss
Hi every one,
i know that we can get that thr above quer..
one can try using analytic function giving ranks to the
salary column
select sal,dense_rank() over(order by sal desc) rank from
emp
Is This Answer Correct ? | 18 Yes | 15 No |
Post New Answer View All Answers
How to write an inner join with the where clause in oracle?
In oracle there is column command, how will you explain that?
What is the relation of a user account and a schema in oracle?
What is blob data type in oracle?
Why does for update in oracle 8 cause an ora-01002 error?
What is Library Cache in Oracle?
How to use windows user to connect to the server?
How to load excel data sheet to oracle database
How view is different from a table?
how to handle exceptions in post production
What is hash cluster in oracle?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What are the ways tablespaces can be managed and how do they differ?
What are a query and state the different types of queries and their uses?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process