4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B
On A.dept_id=B.dept_id
And A.emp_id=B.emp-id;
- 1 Answers
- 2287 Views
- Fintellix, I also Faced
- E-Mail Answers
What is an ndf file?
How do I run a sql trace?
What is rename command in sql?
What do you understand by case manipulation functions?
How can you know that statistics should be updated?
What do you think about pl/sql?
How to assign sql query results to pl sql variables?
What are the advantages of the packages
what is a trigger? : Sql dba
how to include numeric values in sql statements? : Sql dba
Explain the PL/SQL compilation process.
What is a pdo connection?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
