Without a doubt, the most straightforward video (5 min!!!) clearing something up in my last 6 months as a jr. developer. Seriously, this is a cut above, WAY about the usual.
Awesome I must say again! Please what if one just wants to select unique Customer IDs and then give a count of each alone ...i.e to have a table of just unique values of customer IDs with their respective count or sum, without including any other information?
This is a situation where it would be nice if SQL could return an object like: { TotalVal: 1265793.22, Customers:[ 1:{ val:[ 330.00, 472.20, 814.50, 845.80, 878.00, 933.50 ], CustTotalVal:4273.00 }, 2:{ val:[ 88.00, 320.00 479.75, 845.80, 878.00, 933.50 ], CustTotalVal:1402.00 }, ..., ..., ..., ] } Instead of all those duplicate rows that code will need to be used to ignore after the first time its seen. // pseudo customer[id][CustTotalVal] ? (!set) row[CustTotalVal] : customer[id][CustTotalVal] I think MongoDB does that however, it's not generally necessary if your not using a GIANT DB ...But I digress.
We teach SQL Server specifically, though the window function concept exists in other platforms. For example, MySQL has it: dev.mysql.com/doc/refman/8.0/en/window-functions-usage.html
Nice and clean! Thanks for going straight to the point. Please, enable the 'Thanks' button. You deserve it.
Seriously, thank you so much. Exactly what I need in a concise way: over() is like group by without using group by
Glad it was helpful!!
Straight to the point!!! Simple to understand yet surprisingly short! Thanks for This
Thank you, found a very good explanation after watching 5 OVER() videos
After watch a lot of videos, with this video I understood, Thank u soooooooooo much. Greats from Colombia
Glad it helped!
Short, Sweet and To the point! Great lesson!
Without a doubt, the most straightforward video (5 min!!!) clearing something up in my last 6 months as a jr. developer. Seriously, this is a cut above, WAY about the usual.
Thank you from Medellin, Colombia. I've searched a lot about this subject and you in 4 minutes nailed it. Thanks, you're such a great teacher!
How much time I spent googling and couldn't find the right keyword! Your video clear, concise, and just what I needed. Thank you!!
awesome and clear! the phrase 'without narrowing down' totally nailed it concisely
Just needed a quick explanation and you did it beautifully. Thanks.
Great lesson!
Great video!
Thanks!
finally a goddamn good video lol
Thank you so much for explaining in such a simple way!
Great video!..concept explained very well!
Thank you Mama .. good explain with examples
can we apply Over(partition by) using joins and group by ? and how ? could you please make a video on it.
Thank you, I finally understood the OVER() clause
wao! great...
thanks ma'am for the same
Most welcome 😊
Awesome I must say again! Please what if one just wants to select unique Customer IDs and then give a count of each alone ...i.e to have a table of just unique values of customer IDs with their respective count or sum, without including any other information?
Explained it so well!! Thank you!
thank you very much.
How u used aggregate function without group by?
Thank you!
Thank you, to the point!
This is a situation where it would be nice if SQL could return an object like:
{
TotalVal: 1265793.22,
Customers:[
1:{
val:[
330.00,
472.20,
814.50,
845.80,
878.00,
933.50
],
CustTotalVal:4273.00
},
2:{
val:[
88.00,
320.00
479.75,
845.80,
878.00,
933.50
],
CustTotalVal:1402.00
},
...,
...,
...,
]
}
Instead of all those duplicate rows that code will need to be used to ignore after the first time its seen.
// pseudo
customer[id][CustTotalVal] ? (!set) row[CustTotalVal] : customer[id][CustTotalVal]
I think MongoDB does that however, it's not generally necessary if your not using a GIANT DB
...But I digress.
Like + subbed
Excellent, thanks!
Hi, let say I have to reach 330 and 933.50 for the custid 1. How can I make it? I'm searching like 2 hours and I could not get it... Thank you
What if I just wanted custom, totalval and custtotalval?
thank you, good explain!
Is this only for Sql Server?
We teach SQL Server specifically, though the window function concept exists in other platforms. For example, MySQL has it: dev.mysql.com/doc/refman/8.0/en/window-functions-usage.html
sounds like Ellen D. is giving the presentation
That’s exactly what I was thinking!
Thanks
Can u use it in where clause
Gracias
She sounds just like Ellen Degeneres.
I actually get that a lot.
-Jen
I couldn't listen to it, not clear and concise, Yo and Hey
This is so well explained, thanks!