Row_Number & Qualify SQL Tutorial

preview_player
Показать описание
Hi BDEs! ⚡️ Free SQL Course Below ⬇️

If you like this beginner lesson, you’ll LOVE the Big SQL Energy intermediate course which will have you job ready and acing your interviews for your dream data analyst job. We will go into more advanced skills by solving real business problems that I’ve solved on the job as a Senior Data Analyst in tech. At the end, I’ll help you build 2 projects that are exact replicas that I’ve solved in the real world, and then I’ll show you how to add them to your data analytics portfolio.

🤳🏼 SOCIALS
📸 Instagram: @JessRamosData
💙 LinkedIn: Jess Ramos, MSBA
🎬 TikTok: @JessRamosData
  1. Jess Ramos
Рекомендации по теме
Row_Number & Qualify 0:16:08

Row_Number & Qualify SQL Tutorial

SQL Window Functions 0:07:52

SQL Window Functions | Clearly Explained | PARTITION BY, ORDER BY, ROW_NUMBER, RANK, DENSE_RANK

SQL Window Function 0:24:55

SQL Window Function | How to write SQL Query using RANK, DENSE RANK, LEAD/LAG | SQL Queries Tutorial

Intermediate SQL Tutorial 0:04:14

Intermediate SQL Tutorial | Partition By

Row Number function 0:07:24

Row Number function in SQL Server

How to Add 0:08:33

How to Add a Row Number to Your SQL Query Using row_number and partition by

30:QUALIFY | SQL 0:08:05

30:QUALIFY | SQL Tutorial

Qualify:The SQL Filtering 0:05:15

Qualify:The SQL Filtering Statement You Never Knew You Needed - Amanda Fioritto

SQL - How 0:10:07

SQL - How do I get the last row for a given attribute? SQL Window Functions, Row_Number, Qualify

RANK, DENSE_RANK, ROW_NUMBER 0:09:43

RANK, DENSE_RANK, ROW_NUMBER SQL Analytical Functions Simplified

SQL FAANG Interview: 0:02:51

SQL FAANG Interview: QUALIFY clause tested in Google Big Query

SQL QUALIFY Keyword 0:08:41

SQL QUALIFY Keyword | Reduce Your Sub Queries and CTEs

SQL | Which 0:00:51

SQL | Which One To Use? ROW_NUMBER | RANK | DENSE_RANK

SQL - How 0:15:27

SQL - How to Use Qualify Clause

Oracle rownum vs 0:03:08

Oracle rownum vs row number

SQL Window Functions 0:10:13

SQL Window Functions in 10 Minutes

SQL Window Function 0:21:21

SQL Window Function with Example- RANK, DENSE RANK, ROW NUMBER, LEAD/LAG | SQL Tutorial in Hindi 14

Finding Duplicate Rows 0:06:31

Finding Duplicate Rows Using ROW_NUMBER() | Essential SQL

SQL ROW NUMBER 0:12:33

SQL ROW NUMBER Functions | Row Number in SQL Server

SQL in Sixty 0:00:59

SQL in Sixty Seconds: Qualify Clause with Window Functions #dataanalytics #datascience #sql

Where,Having and Qualify 0:06:50

Where,Having and Qualify clause Explanation and Difference in Teradata SQL

SQL: Qualify Clause 0:21:22

SQL: Qualify Clause

The SQL FROM 0:11:06

The SQL FROM Clause

Have you heard 0:00:53

Have you heard of QUALIFY in SQL?

Комментарии
Автор

I'm in the process of completing your hands-on SQL course and I love it! I wanna be like you girl 🥹⚡

barbarasuarez
Автор

never has window functions been made this easy, thank you, please do other videos of window function, funny story I always use it but is always hard for me to explain I just know how it works. this video is magic

phelisiajeruto
Автор

Finally you are on Youtube! Reels were nice but it was too short for me. Subscribed right away.

Hannnkyo
Автор

Thank you so much for sharing your knowledge! ❤

yeste
Автор

This is great Jess! Thanks for sharing!!

DatawithLuis
Автор

explanation is pretty good for understanding. Can you also make videos starting basics first and then advance sql

sahil
Автор

Good one Jess! The explanations were very easy to follow.

vickieab
Автор

Great video! Thanks for helping me continue to learn cool new tricks! I have a question and a suggestion:
- Question: would a case when work in place of qualify since it goes in the select clause?
- Suggestion: on mobile, the text size is difficult to read. Perhaps change the text size to 16 if it isn't necessary to see more rows/columns at the same time.

chrisengledowl
Автор

Can you start from a beginner level? What are window functions and can one get started in beginning a data analyst?

By the way am glad I have found you. Excited for my SQL learning

noriahkatungwe
Автор

@Jess Ramos Nice explanation. Keep it up..! You can do it more mathematics concepts of filters and data cleaning in this data set on next video. To interst learn this video is enough than very lengthy video.

@JessRamosData

GokulS-lxxu
Автор

Hi Jess, What IDE are you using in this tutorial?

pricillanakyazze
Автор

love that you are using hex how do you find it

phelisiajeruto
Автор

Vigilante Shit, I love it. Good stuff Jess. Question for you, what is the "tie break" for row number. Meaning if two rows have the same value, what happens in the sort to choose which is above the other. Is it just the order in the table?

ammansyed
Автор

Here from LinkedIn to learn and shower you with likes and support.

pricillanakyazze
Автор

Hii mam your fan here! Just Subscribed!!

Mam i have a question i want to connect with you on linkedin but i am unable to whenever i try to send a request it says

To verify this member knows you, please enter their email to connect. what should i do mam

sahasbochare
welcome to shbcf.ru