Login Join Now
Products Customers Reference Guides Community About Us
The definitive guide
for data professionals
Sql Tutorial SQL SELECT Statement
SQL Intro
SQL Syntax
SQL Select The SELECT statement retrieves data from a database.
The data is returned in a table-like structure called a result-set.
SQL Where
SELECT is the most frequently used action on a database.
SQL Insert
SQL Update
SQL Delete
SQL Order By
SQL Select Top See 2 min video
SQL Offset-Fetch
SQL Select Distinct
Previous Next
SQL Min, Max
SQL Count, Sum, Avg
SQL And, Or, Not
The SQL SELECT syntax
SQL Between
The general syntax is:
SQL In
SQL Like
1. SELECT column-names
SQL Is Null 2. FROM table-name
SQL Group By
SQL Having To select all columns use *
SQL Alias
SQL Join 1. SELECT *
2. FROM table-name
SQL Left Join
SQL Right Join
SQL Full Join
SQL Self Join
CUSTOMER
SQL Union
Id
SQL Subquery SQL SELECT Examples
FirstName
SQL Any, All
LastName
SQL Exists
Problem: List all customers City
SQL Select Into
Country
SQL Insert Into 1. SELECT * Phone
SQL Injection 2. FROM Customer
SQL Keywords
Results: 91 records
Sql Database
SQL Sandbox Id FirstName LastName City Country Phone
Sample Database 1 Maria Anders Berlin Germany 030-0074321
2 Ana Trujillo México D.F. Mexico (5) 555-4729
3 Antonio Moreno México D.F. Mexico (5) 555-3932
4 Thomas Hardy London UK (171) 555-7788
5 Christina Berglund Luleå Sweden 0921-12 34 65
CUSTOMER
Problem: List the first name, last name, and city of all customers
Id
FirstName
1. SELECT FirstName, LastName, City
2. FROM Customer LastName
City
Country
Results: 91 records Phone
FirstName LastName City
Maria Anders Berlin
Ana Trujillo México D.F.
Antonio Moreno México D.F.
Thomas Hardy London
Christina Berglund Luleå
Previous Next
Company Customers Reference Guides Our Products
About Us Our Customers .NET Design Patterns
.NET Design Pattern Framework TM
Our Story Customer Stories JavaScript Design Patterns
PRO .NET Design Pattern Framework TM
Services
Training JavaScript Tutorial
Community SQL Tutorial JavaScript + jQuery Pattern Framework TM
Contact Us
SQL + Database Pattern Framework TM
Questions Connection Strings
Privacy
Explore Visual Studio Shortcuts Products and Pricing
End User License
Tags C# Coding Standards
Terms
Licensing HTML Colors
© 2019 - Data & Object Factory, LLC. dofactory.com. All rights reserved.
