SQL - Outer Joins, Self Joins
Über den Vortrag
Der Vortrag „SQL - Outer Joins, Self Joins“ von Martin Holzke ist Bestandteil des Kurses „SQL Database for Beginners“. Der Vortrag ist dabei in folgende Kapitel unterteilt:
- Introduction & Outer Joins
- Difference between Outer & Inner Joins
- Difference between Left & Right Join
- Self Joins
Dozent des Vortrages SQL - Outer Joins, Self Joins
Martin Holzke
Martin Holzke’s programming career started while studying Physics in the late 1980’s when he took on an offer to learn to program at Philips instead of the more common student jobs. Once graduated, he started his own business developing applications and systems as a freelance IT Consultant which he does to this day. His 25+ years’ journey continues to take him through a vast array of technologies, methodologies and languages like OOP, UML, C++, .NET, ADF, PHP, Zend, Oracle and SQL to name just a few.Kundenrezensionen
5,0 von 5 Sternen
| 5 Sterne |
|
5 |
| 4 Sterne |
|
0 |
| 3 Sterne |
|
0 |
| 2 Sterne |
|
0 |
| 1 Stern |
|
0 |
Auszüge aus dem Begleitmaterial
... results in records without manager assignment to be excluded. 7) Write a query returning a list of persons including, if assigned, their respective manager. Answer: select p.firstname, p.lastname, m.firstname, m.lastname from person p left join person m on p.managerid=m.id 8) Combine the previous two queries to ensure persons without manager assignment are included in the result. ...
