Answer Posted / keshav
with Q as (select *,dense_rank() over(partition by dept
order by sal) as dr from dept
select * from Q
where dr=3
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
How many unique keys can a table have?
What is sql dialect?
Can I learn sql in a week?
What is rowtype?
Why we use triggers in mysql?
How do I truncate a word?
How many types of functions are there in sql?
how would you enter characters as hex numbers? : Sql dba
what is commit? : Sql dba
explain the difference between myisam static and myisam dynamic. : Sql dba
What is the use of & in pl sql?
What is the difference between joins?
What is embedded sql in db2?
what is schema? : Sql dba
Can dml statements be used in pl/sql?
