5 Basic SELECT Statement Queries in SQL
HTML-код
- Опубликовано: 6 сен 2024
- 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:
Thanks, I'm just starting to learn SQL and this helped a lot. I'm 47 years old. Never stop learning!
10 months on, how is the learning of SQL getting on?
@@rusmw I completed the google data analytics certification. Haven't been practicing lately but thanks for the reminder!
@@tacosmargs58 well done on doing the course, it is an undertaking to follow it through.
college student. Better taught than my classes. Might just pass the class now thank you
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 RUclips before I found your channel. Kinda thrown in the deep end of database concepts class.
0:58 😂😂❤❤
You are brilliant sir. Honestly, you have an easy and laid back way of teaching that’s incredibly relaxing and engaging. Thank you sir!
These videos are so helpful for my college class! Way better than the teacher
Thnks very very much I didn’t even understand one word from the teacher.!!!
So when you select as alias, is the alias stored indefinitely or does it only run for that query?
Pretty cool.
This was a very solid video for quick sql refresh!
How can I sume the screen you see it clearer
really helpful for new sql people!!
Very Helpful for beginners
Thanks 🙏 I needed this … just simply to the point
I love u man. Thanks for the vid
Thank you. Really helpful!
How do i select people whose title of courtesy starts with only Mr. ?
Easy to understand, thanks you🙏
u r the best
Thank you
I wish I could like multiple times
Nice video
Thank you very much
Please explain SELECT statement basic to advanced level including window function
When you create the queries do they save
How to select all invoices from 1 customer
You sound like crazyeyemarketing
I'm not seeing the screen
Skill issue
pls ur name
Thank you
thank you