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
Can I learn sql in a week?
Why do we use joins?
What is the process of debugging?
Can I create table without primary key?
what are the different type of sql's statements ? : Sql dba
What is restrict in sql?
What is a constraint? Tell me about its various levels.
When you have to use a default "rollback to" savepoint of plvlog?
Why do we go for stored procedures?
Is sql low level language?
what is the difference between union and union all? : Sql dba
Mention what does plv msg allows you to do?
What is sql*loader and what is it used for? : aql loader
Which table is left in join?
What is embedded sql with example?