Jump to content

Refresher/SQL/Most Frequently Asked

From Wikiversity

Presentation

Basic Concepts
Basic Concepts
Most Frequently Asked
Comprehensive Tutorial
Comprehensive Tutorial
List of Topics
List of Topics
   
This presentation was made possible by Wikiversal/WikiverSuite, which is made possible by your donation. Thank you for your support.
This presentation was made possible by Wikiversal/WikiverSuite, which is made possible by your donation. Thank you for your support.
Comprehensive Tutorial
Comprehensive Tutorial
 Inner join: intersection, e.g. SELECT Person.LastName, Person.FirstName, Sales.OrderNo FROM Person INNER JOIN Sales ON Person.P_Id=Sales.P_Id ORDER BY Person.LastName
 
 Outer join: union, e.g.
 
 Foreign key: primary key of another table.