All About SQL Aggregations | SQL Advance | Zero to Hero

Fantastic.

Brother I have a problem in sql. Sum function give threefold or fourfold result with join query. could you please spend time fom me? I have shown the problem many yutube expert but they are procrastinating only. Thanks

Please add video on partition by multiple columns

Nice way of teaching🙂

Great content and clear explanation of aggregate/window functions.
With using over (order by order_date), result set will be sorted whereas using over (order by order_date with rows between unbounded preceding and current row) result set will not be sorted in any order. Is that right ?

Sir. Great Video. You said that you will tell the differences between normal running sum and unbounded preceding and current row.

Sir Hindi me vedio banaye please and each step explain why you are doing in hindi

which database you have used in this tutorial Ankit ji

Hi sir can you create videos from scratch for beginners

Amazing. Thank you so much

For those of you writing your sql query on Postgresql. You can create the same table here in this Postgresql-compatible format:
CREATE TABLE int_orders (
order_number integer NOT NULL,
order_date date NOT NULL,
cust_id integer NOT NULL,
salesperson_id integer NOT NULL,
amount float NOT NULL
);

INSERT INTO int_orders (order_number, order_date, cust_id, salesperson_id, amount)
VALUES (30, DATE '1995-07-14', 9, 1, 460);

INSERT INTO int_orders (order_number, order_date, cust_id, salesperson_id, amount)
VALUES (10, DATE '1996-08-02', 4, 2, 540);

INSERT INTO int_orders (order_number, order_date, cust_id, salesperson_id, amount)
VALUES (40, DATE '1998-01-29', 7, 2, 2400);

INSERT INTO int_orders (order_number, order_date, cust_id, salesperson_id, amount)
VALUES (50, DATE '1998-02-03', 6, 7, 600);

INSERT INTO int_orders (order_number, order_date, cust_id, salesperson_id, amount)
VALUES (60, DATE '1998-03-02', 6, 7, 720);

INSERT INTO int_orders (order_number, order_date, cust_id, salesperson_id, amount)
VALUES (70, DATE '1998-05-06', 9, 7, 150);

INSERT INTO int_orders (order_number, order_date, cust_id, salesperson_id, amount)
VALUES (20, DATE '1999-01-30', 4, 8, 1800);

excellent

Maza agya, Thank you Ankit. Knowing how to work with lead and lag fn w/o actually using them, instead using preceding/following is awesome.

i just love the way you teach

Why it gives running sum only when we use order by?

hi ankit 17/32
video completed

Hello Ankit
I have one question.
As you said we can use 1 preceding and 1 preceding function which works similar to Lag function. But let's say when there is too much data in the database and if we use the " 1 preceding and 1 preceding " function then how the system will behave in terms of performance. Can we use " 1 preceding and 1 preceding " for query optimisation???

Share sql playlist please

Very well explained. Thanks for sharing amazing content as you always do.

masterclass to clear aggregation concepts once and for all. Thanks Ankit.

When creating the tables
Why the columns and insert datais kept in the braces

kuch samjh nehi aya bhai please try to explain why instead of saying the same thing in english

i asked my trainer but this solved my problem!! Thanks sir

Just a masterclass, the way you teach is simply outstanding ....Jem of a person :)

This is awesome.. 😎

Thanks for your videos. I have learned a lot. I believe it is not easy to make videos. Thanks for your time.

Came across this video today and thought of checking to refresh concepts and i would say you explained every aspect and usecase of aggregation functions very well !

Excellent Explanation... Wat a Class Sir ... Brilliant ...😍😍🤩🤩🤩

Loved it! you nailed it. Keep growing and keep sharing! 😍

Your way of approach and explanation was excellent.

Hi Ankit, Thanks for posting this video I went through this and understood whole concept. I really appreciate you for explaining in simple way. Thanks Again!

It would have been nice if you had explained with examples.

Great and Excellent teaching. Thank you for sharing. I have learned a lot.

Hello Sir,
Can you explain how unbounded preceding and current row is different from just order by order_date. Query would give the same result I believe

Awesome video! Cleared all my doubts around aggregation functions in SQL.

One of the best few videos on Window Functions!
Or I must say 'The Best'...

Awesome video❤

Very well...
Really learning....

Much appreciated. You are really inspiring to learn SQL interestingly. God bless you and all the best.

Best Explanation on Window function, Thank you so much!!

Awesome Bro.. !!!

I saw a question in Leetcode 619

A single number is a number that appeared only once in the MyNumbers table. Find the largest single number. If there is no single number, report null:

why this worked:
select max(num) as num
from (select num from MyNumbers
group by num
having count(*) = 1) a

and this didn't:
select max(num) as num
from from MyNumbers
group by num
having count(num) = 1

You sir are an amazing teacher!

THANK YOU! This is one of the best sql explanation tutorial I have seen. It helps a lot!

Hi Ankit, could you pls do one video on table partitioning??

god bless you Ankit

very nice way of explaining. Like the pace and keeps it interesting

Crisp and clear