Interested to Buy Any Domain ? << Click Here >> for more details...
i want department wise maxmum salary and empolyee name
- 9 Answers
- 29357 Views
- I also Faced
- E-Mail Answers
Answer Posted / sanjaya
select distinct deptno, max(sal)over ( partition by deptno order by deptno) from emp;
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the various constraints used in oracle?
What is the difference between translate and replace?
What is the difference between "as" and "is" in an oracle stored procedure?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
candidate key is subset of super key but not vice-verse explain
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How to list all indexes in your schema?
What do you mean by a tablespace?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What happens in oracle commit?
How to drop an index in oracle?
Explain the use of full option in exp command.
How to convert characters to times in oracle?
What is merge statement used for?
What happens if the imported table already exists?
