Refresher/SQL/Most Frequently Asked

From Wikiversity
Jump to navigation Jump to search

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.
 
Mobile version