5 Basic SELECT Statement Queries in SQL

Here are 5 Basic SELECT Statement Queries in SQL so you can begin pulling the information you need out of your database and tables!

Query demos:
1) Select ALL from a table: SELECT * FROM table
2) Select certain columns from a table: SELECT column1, column2, column3 FROM table
3) Select all the unique or distinct rows in a column from a table. Another way to think of it is "removing duplicates": SELECT DISTINCT column FROM table
4) Change the displayed name of your columns by adding Aliases: SELECT column1 AS alias1, column2 AS alias 2 FROM table
5) Add arithmetic in your SELECT statement by using mathematical expressions: SELECT quantity*price AS total_price FROM table

Get the Northwind Database:    • How to Load a Sample PostgreSQL Datab...  

Support the Channel:
1) Subscribe:
2) DataCamp:
3) Udacity: