Interested to Buy Any Domain ? << Click Here >> for more details...
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
Why does sql need a server?
How do you create a db file?
What is sqlca in db2?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
What is on delete set null?
explain primary keys and auto increment fields in mysql : sql dba
What is coalesce sql?
what is a join? : Sql dba
What is a column in a table?
Can we use views in stored procedure?
How can a pl sql block be executed?
Is it possible to link two groups inside a cross products after the cross products group has been created?
How do I add a database to sql?
describe transaction-safe table types in mysql : sql dba
How long it takes to learn pl sql?
