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
- 30494 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
how to get @@error and @@rowcount at the same time? : Sql dba
Which are sql * plus commands?
What is function and procedure?
What is a procedure in pl sql?
What are pl sql procedures?
Name three sql operations that perform a sort.
What is field delimiter?
What are operators available in sql?
What is meant by temporal data?
What are hotfixes and patches?
How do you explain an index?
Can we use joins in subquery?
What is a pragma statement?
What is user defined functions?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
