SQL QUALIFY Keyword | Reduce Your Sub Queries and CTEs

In this video we will learn about SQL Qualify clause which can really reduce your sub queries and CTEs. It makes your code much cleaner and easy to read. Qualify clause is used to filter the data based on window functions.
Zero to hero(Advance) SQL Aggregation:
• All About SQL Aggregat...
Most Asked Join Based Interview Question:
• Most Asked SQL JOIN ba...
Solving 4 Trick SQL problems:
• Solving 4 Tricky SQL P...
Data Analyst Spotify Case Study:
• Data Analyst Spotify C...
Top 10 SQL interview Questions:
• Top 10 SQL interview Q...
Interview Question based on FULL OUTER JOIN:
• SQL Interview Question...
Playlist to master SQL :
• Complex SQL Questions ...
Rank, Dense_Rank and Row_Number:
• RANK, DENSE_RANK, ROW_...
#sql #analytics #bigquery

[@ankitbansal6]

Start your analytics journey :
www.namastesql.com/

[@sahilchaudhry100]

Hello Ankit sir, this question can also be solved by simply doing group by on company and choosing max(trip_total) right? You have used window function to explain the concept, but otherwise the highest amount for each company can be calculated with group by and max function also right?

[@ankitbansal6]

But you won't get other details of each driver

[@sahilchaudhry100]

@@ankitbansal6 correct sir. Thank you.

[@Vonneuman8676]

Grateful to you for enlightening and strengthen SQL journey in very simplified manner as possible

[@srinubathina7191]

Thank You Ankit Bro

[@utkarshdixit3502]

Great video ❤

[@nkkumari998]

To calculate the percentage of sales for each month based on the last 6 months of sales...
Sir, could you please provide the answer to this question? I'm feeling quite confused about it..pls sir

[@Ankit-rv2my]

Hello Ankit, Could please make a video on non-equi join and find number of records from 2 tables ?

[@harikrishnai4508]

U should say this is the function of mysql right ? , I was stunned to see ur add or some thing why I didn't find it in ms sql 😢.

[@pravinmahindrakar6144]

Are you teaching GCP for data engineer?

[@souvik5560]

Please start a Full SQL course[Live and recorded], covering all the topics.
It seems like an ocean. Every day some or the other topic crops up.

[@ankitbansal6]

It's already there on namaste SQL website

[@trentlandon9033]

I have a query which has many functions in it.. The query is taking too much time to fetch 100 thousands data... How can i reduce time in such scenario

[@ankitbansal6]

Depends on query 😊

[@Mathematica1729]

Quite useful.

[@ankitbansal6]

Absolutely 😊