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 Database i...
Support the Channel:
1) Subscribe:
2) DataCamp:
3) Udacity:
On this page of the site you can watch the video online 5 Basic SELECT Statement Queries in SQL with a duration of hours minute second in good quality, which was uploaded by the user Becoming a Data Scientist 04 January 2020, share the link with friends and acquaintances, this video has already been watched 165,087 times on youtube and it was liked by 2.6 thousand viewers. Enjoy your viewing!
