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:
Watch video 5 Basic SELECT Statement Queries in SQL online without registration, duration hours minute second in high quality. This video was added by user Becoming a Data Scientist 04 January 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 151,207 once and liked it 2.4 thousand people.