Скачать или смотреть PERCENTILE DISC analytic function in SQL Server - #8

#SQLServer #PERCENTILEDISC #Analytics #DataAnalysis #SQLExamples #AnalyticFunctions #SQLTips #DatabaseDevelopment #SQLQueries #DataScience #SQLLearning #BusinessIntelligence #TechEducation #DataEngineering #ProgrammingTips #Technology #BigData #DatabaseManagement #TechCommunity #DataInsights

Playlist -    • CUME_DIST analytic function in SQL Server ...  
------------------------------------------------------------------------------------------
CUME_DIST() -    • CUME_DIST analytic function in SQL Server ...  
PERCENT_RANK() -    • PERCENT_RANK analytic function in SQL -#2 ...  
FIRST_VALUE() -    • FIRST_VALUE Analytic Function in SQL Serve...  
LAST_VALUE() -    • LAST_VALUE Analytic Functions in SQL Serve...  
LEAD() -    • LED Analytic Function in SQL  - #5 #SQL #L...  
LAG() -    • LAG Analytic Function in SQL Server - #6 #...  
PERCENTILE_CONT() -    • PERCENTILE_CONT analytic function in SQL S...  
PERCENTILE_DISC() -    • PERCENTILE DISC analytic function in SQL S...  
------------------------------------------------------------------------------------------

QUERY SOLVE -
1. Analytic functions in SQL Server
2. PERCENTILE_DISC analytic functions in SQL Server
4. Syntax of PERCENTILE_DISC analytic functions
5. What is partition by clause in SQL Server?
6. Order by clause in SQL Server
7. Default parameters of PERCENTILE_DISC analytic functions in SQL Server.
8. Get discrete distribution median value use of PERCENTILE_DISC analytic function.
9. Deference between PERCENTILE_DISC and PERCENTILE_CONT function in SQL Server

PERCENTILE_DISC ()
The PERCENTILE_DISC analytic function Computes a specific percentile for sorted values in an entire row set or within distinct partitions of a row set . For a given percentile value P, PERCENTILE_DISC sorts the values of the expression in the ORDER BY clause. For example, PERCENTILE_DISC (0.5) will compute the 50th percentile (that is, the median) of an expression. PERCENTILE_DISC calculates the percentile based on a discrete distribution of the column values. The result is equal to a specific column value.

Syntax :
PERCENTILE_DISC ( numeric_literal )
WITHIN GROUP ( ORDER BY order_by_expression )
OVER ( [ partition_by_clause ] )

Numeric_literal:
The percentile to compute. The value must range between 0.0 and 1.0.

WITHIN GROUP ( ORDER BY order_by_expression )
Specifies a list of values to sort and compute the percentile over. Only one order_by_expression is allowed. The return type is determined by the order_by_expression type.

OVER ( partition_by_clause):
Divides the FROM clause's result set into partitions. The percentile function is applied to these partitions.

Query :
SELECT [Name],
[Price],
[Type],
PERCENTILE_DISC(0.5) WITHIN GROUP (ORDER BY Price)
OVER (PARTITION BY [Type]) AS [0.5 PERCENTILE_DISC]
FROM [DbSample].[dbo].[Bikes2] where Make = 'Yamaha'

Chapter :
00:40 Basic definition of PERCENTILE_DISC function
02:01 Basic deference between PERCENTILE_DISC and PERCENTILE_CONT function
03:45 Implementing PERCENTILE_DISC function in SQL Server
09:01 Deference between PERCENTILE_DISC and PERCENTILE_CONT function

Thanks for watching this video.
EVERYDAY BE CODING