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
- 2724 Views
- Fintellix, I also Faced
- E-Mail Answers
What is the difference between stored procedure and view?
What is a join?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
Will truncate release space?
What does trigger mean in psychology?
using comand prompt how can import table data and table space with example
Can we rollback after truncate?
query to retrive the employees whose sal is greater than avg sal
Define union, minus, union all, intersect ?
Can we join two tables without common column?
What is the use of function "module procedure" in pl/sql?
what is the use of set statement in tsql? : Transact sql
-
Oracle (3259) - 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)
