HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG
WITH DEPARTMENT NAMES? E.g EMP,DEPT
Answer Posted / guest
select *from emp where max(sal)=dept;
| Is This Answer Correct ? | 2 Yes | 16 No |
Post New Answer View All Answers
How to define a procedure inside another procedure?
How to create a table interactively?
How many anonymous blocks can be defined?
What is a sub query? What are its various types?
How to change user password in oracle?
What happens if recursive calls get out of control?
How to sort output in descending order in oracle?
How to connect to the server with user account: sys?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
1) Does oracle have any table which contain all the exceptions and it's code internally?
WHAT IS ecc 6.0
Can a formula column be obtained through a select statement ?
What is procedure overloading in oracle?
What is a data lock in oracle?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?