Тёмный
No video :(

How To Use SQL To Calculate The Percentage Of A Total and Percentage Of Customer Spend 

Matador Software
Подписаться 8 тыс.
Просмотров 16 тыс.
50% 1

In this short tutorial, I'll cover how we can simply use SQL to calculate the percentage of total customer spend using Partitions & Functions within SQL Server.
Before we dive into SSMS, I'll go through slides to explain our base table and a breakdown of our expected output.
Enjoy!
🤝 Follow my Data content on Twitter:
/ matadorsoftware
🤝 I’m also sharing Data knowledge on Instagram:
/ matador_sof. .
🤝 Connect with me on LinkedIn:
/ ja376
🤝 View my Website:
www.matadorsof...
#sql #sqlserver

Опубликовано:

 

26 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 3   
@edwinrojas7172
@edwinrojas7172 4 месяца назад
bro, you are the Best, thanks
@SameerHussain-qk8ul
@SameerHussain-qk8ul Год назад
If I want to get the percentage based on the customer total and date, how can that be done? So like I get distribution of total in terms of sum, and percentage for each customer on a given date.
@MatadorSoftware
@MatadorSoftware Год назад
You just need to partition by/ use the over clause on the relevant fields, such as date and then group your results
Далее
Cute kitty gadgets 💛
00:24
Просмотров 12 млн
Stop using COUNT(id) to count rows
7:01
Просмотров 373 тыс.
How to Move Data Automatically Between Excel Files
11:37
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
microsoft doubles down on recording your screen
10:00
Nested Queries | SQL | Tutorial 18
10:23
Просмотров 177 тыс.
Cute kitty gadgets 💛
00:24
Просмотров 12 млн