A left outer join B
B right outer join A gives the same result then what is
the use of two?
Answer / nithya
Is ur query used in any situation? bcos
In general join is used in the following case:
consider "Persons" table:
P_Id LastName FirstName Address City
1 Hansen Ola Timoteivn 10 Sandnes
2 Svendson Tove Borgvn 23 Sandnes
3 Pettersen Kari Storgt 20 Stavanger
"Orders" table:
O_Id OrderNo P_Id
1 77895 3
2 44678 3
3 22456 1
4 24562 1
5 34764 15
left outer join:
SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo
FROM Persons
LEFT outer JOIN Orders
ON Persons.P_Id=Orders.P_Id
ORDER BY Persons.LastName
The result-set will look like this:
LastName FirstName OrderNo
Hansen Ola 22456
Hansen Ola 24562
Pettersen Kari 77895
Pettersen Kari 44678
Svendson Tove
right outer join:
SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo
FROM Persons
RIGHT JOIN Orders
ON Persons.P_Id=Orders.P_Id
ORDER BY Persons.LastName
The result-set will look like this:
LastName FirstName OrderNo
Hansen Ola 22456
Hansen Ola 24562
Pettersen Kari 77895
Pettersen Kari 44678
34764
Is This Answer Correct ? | 3 Yes | 0 No |
Write a SQL Query to find first Week Day of month?
What is thr feature of change data capture?
What are the differences between left join and inner join in sql server?
What is transactional replication?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What is cte (common table expression)?
What can be used instead of trigger?
Can you name a few encryption mechanisms in sql server?
write a query to remove duplicate records without using primary key column?
Are null values the same as that of zero or a blank space?
What stored by the msdb? : sql server database administration
What are different types of raid levels?