SELECT Clause in SQL: SQL 30 Day Challenge Day 6

Sdílet
Vložit
  • čas přidán 18. 06. 2024
  • Day 6 is all about selecting columns from tables, selecting unique (distinct) values from within columns to explore our data, and renaming columns using aliases. Learn SELECT *, SELECT DISTINCT, and the keyword 'AS' to query tables in SQL.
    -----------------------------------------------------------------
    Download SQLite Studio Here: sqlitestudio.pl/
    Download the Chinook Database: www.sqlitetutorial.net/sqlite...
    Link to Topic List: docs.google.com/document/d/1f...
    Link to Facebook Support Group: / 767988395118964
    Link to my Data Etsy Shop (support me to keep making content): jellysgeekygoods.etsy.com
    Buy me a coffee to show support: buymeacoffee.com/learningwith...
    #sql #sqltutorial #sqlforbeginners

Komentáře • 3

  • @ngaybepavel6362
    @ngaybepavel6362 Před 14 dny

    Is it necessary to enclose the alias in quotes, or is it a convention with SQLite?

Další v pořadí
Automatické přehrávání
Mini SQL Project for Creating Tables: SQL 30 Day Challenge Day 715:47Mini SQL Project for Creating Tables: SQL 30 Day Challenge Day 7
Mini SQL Project for Creating Tables: SQL 30 Day Challenge Day 7Learning with Jelly
zhlédnutí 133
WHERE Clause in SQL: SQL 30 Day Challenge Day 818:52WHERE Clause in SQL: SQL 30 Day Challenge Day 8
WHERE Clause in SQL: SQL 30 Day Challenge Day 8Learning with Jelly
zhlédnutí 113
JOINS in SQL Part Two: SQL 30 Day Challenge Day 1522:22JOINS in SQL Part Two: SQL 30 Day Challenge Day 15
JOINS in SQL Part Two: SQL 30 Day Challenge Day 15Learning with Jelly
zhlédnutí 82
Survival skills: A great idea with duct tape #survival #lifehacks #camping00:27Survival skills: A great idea with duct tape #survival #lifehacks #camping
Survival skills: A great idea with duct tape #survival #lifehacks #campingKirill Multitool
zhlédnutí 57M
Honesty Test at Store After Cashier's Nap #shorts00:17Honesty Test at Store After Cashier's Nap #shorts
Honesty Test at Store After Cashier's Nap #shortsFabiosa Best Lifehacks
zhlédnutí 5M
Co Dostaneš z Matiky?00:19Co Dostaneš z Matiky?
Co Dostaneš z Matiky?Taky Bige
zhlédnutí 210K
Incredible magic 🤯✨00:53Incredible magic 🤯✨
Incredible magic 🤯✨America's Got Talent
zhlédnutí 29M
"I Hate Agile!" | Allen Holub On Why He Thinks Agile And Scrum Are Broken8:33"I Hate Agile!" | Allen Holub On Why He Thinks Agile And Scrum Are Broken
"I Hate Agile!" | Allen Holub On Why He Thinks Agile And Scrum Are BrokenContinuous Delivery
zhlédnutí 138K
How does ID Statement work while transposing data || SAS Interview Question and Answer6:08How does ID Statement work while transposing data || SAS Interview Question and Answer
How does ID Statement work while transposing data || SAS Interview Question and AnswerSAS Solutions
zhlédnutí 69
ORDER BY Clause in SQL: SQL 30 Day Challenge Day 912:33ORDER BY Clause in SQL: SQL 30 Day Challenge Day 9
ORDER BY Clause in SQL: SQL 30 Day Challenge Day 9Learning with Jelly
zhlédnutí 76
I bought the most MINIMALIST Tech ever.48:11I bought the most MINIMALIST Tech ever.
I bought the most MINIMALIST Tech ever.Mrwhosetheboss
zhlédnutí 7M
Data Modeling Tutorial: Star Schema (aka Kimball Approach)16:34Data Modeling Tutorial: Star Schema (aka Kimball Approach)
Data Modeling Tutorial: Star Schema (aka Kimball Approach)Kahan Data Solutions
zhlédnutí 97K
UPDATE, DELETE FROM, ALTER TABLE SQL Commands: SQL 30 Day Challenge Day 1016:22UPDATE, DELETE FROM, ALTER TABLE SQL Commands: SQL 30 Day Challenge Day 10
UPDATE, DELETE FROM, ALTER TABLE SQL Commands: SQL 30 Day Challenge Day 10Learning with Jelly
zhlédnutí 80
Materialized View in SQL | Faster SQL Queries using Materialized Views16:40Materialized View in SQL | Faster SQL Queries using Materialized Views
Materialized View in SQL | Faster SQL Queries using Materialized ViewstechTFQ
zhlédnutí 101K
"Stop Using Async Await in .NET to Save Threads" | Code Cop #01814:05"Stop Using Async Await in .NET to Save Threads" | Code Cop #018
"Stop Using Async Await in .NET to Save Threads" | Code Cop #018Nick Chapsas
zhlédnutí 67K
Subqueries in SQL: SQL 30 Day Challenge Day 1621:58Subqueries in SQL: SQL 30 Day Challenge Day 16
Subqueries in SQL: SQL 30 Day Challenge Day 16Learning with Jelly
zhlédnutí 105
Any surprise you??00:22Any surprise you??
Any surprise you??Josh Horton
zhlédnutí 34M
TeamBrichta na Clash of the Stars 8 | feat Jakub Wikłacz & Losene Keita20:30TeamBrichta na Clash of the Stars 8 | feat Jakub Wikłacz & Losene Keita
TeamBrichta na Clash of the Stars 8 | feat Jakub Wikłacz & Losene KeitaTeamBrichta
zhlédnutí 135K
Hádej Youtubera! Dodo vs. Barča16:59Hádej Youtubera! Dodo vs. Barča
Hádej Youtubera! Dodo vs. Barča Dodo dva
zhlédnutí 123K
I lift so my son can win this argument🫡00:24I lift so my son can win this argument🫡
I lift so my son can win this argument🫡Noel Deyzel
zhlédnutí 80M
Despicable Me 4? OH YEAH!00:12Despicable Me 4? OH YEAH!
Despicable Me 4? OH YEAH!_vector_
zhlédnutí 3,5M
Kendrick Lamar - Not Like Us05:55Kendrick Lamar - Not Like Us
Kendrick Lamar - Not Like UsKendrickLamarVEVO
zhlédnutí 30M
I wish I could change THIS fast! 🤣00:33I wish I could change THIS fast! 🤣
I wish I could change THIS fast! 🤣America's Got Talent
zhlédnutí 108M
🚫➡️🛠️ DIY Asphalt Repair: Transforming Potholes Step-by-Step! 🛣️00:54🚫➡️🛠️ DIY Asphalt Repair: Transforming Potholes Step-by-Step! 🛣️
🚫➡️🛠️ DIY Asphalt Repair: Transforming Potholes Step-by-Step! 🛣️Crafty Champions
zhlédnutí 29M