Answer Posted / farrukh shaikh
select vu.sal from
(select DENSE_RANK() over(order by sal desc) as sr,
sal from emp) vu
where vu.sr=3
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
How do you know if a relationship is 2nf?
what is an alias command? : Sql dba
What is forward declaration in pl sql?
What is union and union all keyword in sql and what are their differences?
What is on delete set null?
can sql servers linked to other servers like oracle? : Sql dba
what are dynamic queries in t-sql? : Transact sql
what is denormalization. : Sql dba
Explain the working of foreign key?
Why is theta join required?
How to set up sql*plus output format in oracle?
Explain how to use transactions efficiently : transact sql
What is a memo field?
What are the three forms of normalization?
tell us something about heap tables. : Sql dba