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
- 31166 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
What is db journal file?
What is cold data?
What is view explain with example?
What is trigger with example?
How to start the command-line sql*plus?
What do we need to check in database testing?
How does cross join work?
Explain the the delete statements in sql?
Differentiate pl/sql and sql?
how is myisam table stored? : Sql dba
What is the difference between the conventional and direct path loader? : aql loader
What is plpgsql language?
What is difference between table and view?
What is rename command in sql?
What are the types of functions in sql?
