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

Support the Channel:

[Mrhoboman]

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

[tacosmargs]

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

[embisonjones]

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

[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 YouTube before I found your channel. Kinda thrown in the deep end of database concepts class.

[amberpitt]

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

[arianaamores]

Thanks 🙏 I needed this … just simply to the point

[Titanvol]

This was a very solid video for quick sql refresh!

[emmswarega]

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

[linnerellie]

When you create the queries do they save

[muktarseid]

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

[baskarnallusamy]

Please explain SELECT statement basic to advanced level including window function

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

How to select all invoices from 1 customer