Interested to Buy Any Domain ? << Click Here >> for more details...
consider a table which contain 4 columns,ename,eno,sal and
deptno, from this table i want to know ename who having
maximum salary in deptno 10 and 20.
- 24 Answers
- 29525 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / ashim
select * from (select id,dept,sal,dense_rank() over
(partition by dept order by sal desc) p from a_tab1)
where p=1
....by using this program we can find out the nth salary of
different department jus give p=n
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is grant a ddl statement?
Can we use joins in subquery?
How to make a copy values from one column to another in sql?
Why are indexes and views important to an organization?
What is compute?
explain mysql aggregate functions. : Sql dba
What is full form of rtm?
How do I find duplicates in sql?
Is nosql relational?
Explain the significance of the & and && operators in pl sql.
How many sql are there?
How do I remove sql developer from windows 10?
how to extract a unit value from a date and time? : Sql dba
What is the example of procedure?
How do I partition in sql?
