How do you get all records from 2 tables. Which join do you use?
Answers were Sorted based on User's Feedback
Answer / pervez
using full outer join or Cartesian join we can get all records
from two tables
Is This Answer Correct ? | 8 Yes | 3 No |
Answer / gvmahesh
full outer join.
select ename,sal,dname,loc,e.deptno from emp e
full outer join dept d on e.deptno=d.deptno;
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / kavithanedigunta
full outer join in 10 g
select a.*,d.dname
from emp a
full outer join
dept d on
a.DEPTNO = d.DEPTNO
full outer join in 9i
select a.* ,d.DNAME
from emp a, dept d
where a.DEPTNO = d.DEPTNO
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / selvaraj v , anna univ coe
Use Full Outer Join in Oracle 10g :
SELECT p.part_id,s.supplier_name FROM part p
FULL OUTER JOIN
supplier s ON p.supplier_idv = s.supplier_id;
Is This Answer Correct ? | 3 Yes | 1 No |
Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-Tree Index
Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.
Is sql developer case sensitive?
Delete duplicate records in the emp table.
What are the string functions in sql?
sql query to get zero records from a table having n no of records
What are triggers in sql?
Is id a reserved word in sql?
What is coalesce in sql?
How to access the current value and next value from a sequence?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?