How does cross join work?
No Answer is Posted For this Question
Be the First to Post Answer
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;
use of IN/ANY/ALL
What are sql objects?
Write a query to display the current date in sql?
What is spool?
what is the output of this query selet * from employee where 1=2 ??
Are subqueries better than joins?
How can we debug in PL/SQL?
How many LONG columns are allowed in a table?
What is difference between hql and sql?
How can I make sql query run faster?
What are basic techniques of indexing?
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)