Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2804 Views
- Fintellix, I also Faced
- E-Mail Answers
What are different types of statements supported by sql?
what command is used to create a table by copying the structure of another table including constraints ?
What is substitution variable?
If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?
How to use transactions efficiently : transact sql
What is sql stand for?
if a table is getting updated what happens if a function is called from sql query?
What is the difference among union, minus and intersect?
How is data stored on a disk?
Is pl sql and postgresql same?
Does inner join remove duplicates?
What is denormalization in a database?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
