5 Basic SELECT Statement Queries in SQL

Рет қаралды 119,669

4 жыл бұрын

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: www.becomingads.com/o/youtube
2) DataCamp:
3) Udacity:

Пікірлер: 34

@123Mrhoboman 3 жыл бұрын

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

@tacosmargs58 10 ай бұрын

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

@rusmw 11 күн бұрын

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

@tacosmargs58 10 күн бұрын

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

@rusmw 10 күн бұрын

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

@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 2 жыл бұрын

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

@arianaamores7147 Жыл бұрын

Thanks 🙏 I needed this … just simply to the point

@Cdanne 2 жыл бұрын

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

@user-jj7ud3wr3s 3 ай бұрын

0:58 😂😂❤❤

@juliakristavilladiego4425 3 жыл бұрын

Thank you. Really helpful!

@hamzalong1511 Жыл бұрын

really helpful for new sql people!!

@syukraakhmad3822 Жыл бұрын

Easy to understand, thanks you🙏

@emmanuelolisa6981 Жыл бұрын

I love u man. Thanks for the vid

@niteshmishra3923 3 жыл бұрын

Very Helpful for beginners

@Titanvol91 11 ай бұрын

This was a very solid video for quick sql refresh!

@EddieBiago 2 ай бұрын

How can I sume the screen you see it clearer

@vismayan573 Жыл бұрын

Thank you very much

@lucatintor4896 Жыл бұрын

Thank you

@rock20711 4 ай бұрын

u r the best

@d.o.nmuzic3802 Жыл бұрын

thank you

@shreyanshushukla7096 3 жыл бұрын

Nice video

@muktarseid7584 5 ай бұрын

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

@emmswarega2658 Жыл бұрын

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

@queensheba9769 Жыл бұрын

I wish I could like multiple times

@baskarnallusamy994 2 жыл бұрын

Please explain SELECT statement basic to advanced level including window function

@linnerellie209 Жыл бұрын

When you create the queries do they save

@S.A.M.U.R.A.I.7 3 жыл бұрын

How to select all invoices from 1 customer

@gagankumar4989 Жыл бұрын

You sound like crazyeyemarketing

@EddieBiago 2 ай бұрын

I'm not seeing the screen

@youssef7391 18 күн бұрын

Skill issue

@SegunOmotosho-jg4ub Жыл бұрын

pls ur name

@khattak9376 6 ай бұрын

Thank you