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 P...
Support the Channel:
1) Subscribe:
2) DataCamp:
3) Udacity:

[@tacosmargs58]

Thanks, I'm just starting to learn SQL and this helped a lot. I'm 47 years old. Never stop learning!

[@rusmw]

10 months on, how is the learning of SQL getting on?

[@tacosmargs58]

@@rusmw I completed the google data analytics certification. Haven't been practicing lately but thanks for the reminder!

[@rusmw]

@@tacosmargs58 well done on doing the course, it is an undertaking to follow it through.

[@123Mrhoboman]

college student. Better taught than my classes. Might just pass the class now thank you

[@pablitocodes]

your cs teachers are just tenured folks like me who need a job. Unfortunately most of us can't teach lol. Sorry about that :p

[@AhmedG-tv]

Literally 😂

[@Cdanne]

I might not drop my class because of you. Thank you! You're an incredibly easy to understand teacher. I spent over an hour scouring UA-cam before I found your channel. Kinda thrown in the deep end of database concepts class.

[@JohnnyWebb-q1y]

0:58 😂😂❤❤

[@embisonjones4996]

You are brilliant sir. Honestly, you have an easy and laid back way of teaching that’s incredibly relaxing and engaging. Thank you sir!

[@amberpitt2674]

These videos are so helpful for my college class! Way better than the teacher

[@muktarseid7584]

Thnks very very much I didn’t even understand one word from the teacher.!!!

[@hamzalong1511]

really helpful for new sql people!!

[@emmanuelolisa6981]

I love u man. Thanks for the vid

[@Titanvol91]

This was a very solid video for quick sql refresh!

[@EddieBiago]

How can I sume the screen you see it clearer

[@niteshmishra3923]

Very Helpful for beginners

[@juliakristavilladiego4425]

Thank you. Really helpful!

[@emmswarega]

How do i select people whose title of courtesy starts with only Mr. ?

[@paulking75]

So when you select as alias, is the alias stored indefinitely or does it only run for that query?

[@syukraakhmad3822]

Easy to understand, thanks you🙏

[@rock20711]

u r the best

[@shreyanshushukla7096]

Nice video

[@gergarfritz3442]

Pretty cool.

[@linnerellie209]

When you create the queries do they save

[@queensheba9769]

I wish I could like multiple times

[@vismayan573]

Thank you very much

[@baskarnallusamy994]

Please explain SELECT statement basic to advanced level including window function

[@S.A.M.U.R.A.I.7]

How to select all invoices from 1 customer

[@d.o.nmuzic3802]

thank you

[@gagankumar4989]

You sound like crazyeyemarketing

[@EddieBiago]

I'm not seeing the screen

[@youssef7391]

Skill issue

[@SegunOmotosho-jg4ub]

pls ur name

[@arianaamores7147]

Thanks 🙏 I needed this … just simply to the point

[@lucatintor4896]

Thank you

[@khattak9376]

Thank you