Why do we use joins in sql?
No Answer is Posted For this Question
Be the First to Post Answer
What is a table?
describe transaction-safe table types in mysql : sql dba
How does cross join work in sql?
Which one is the Best approach to put code, among Triggers and Procedures? Explain?
What company owns postgresql?
How to copy a table in another table with datas?
wht is the difference between sqlaserver2000 and 2005
What is the best partition size for windows 10?
who introduced sql?
Can a table have no primary key?
What is union?
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;
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)