PERCENTILE DISC analytic function in SQL Server

Time Stamps:
0:40 to 2:00 - Basic definition of PERCENTILE_DISC function
2:01 to 3:38 - Basic deference between PERCENTILE_DISC and PERCENTILE_CONT function
3:45 to 9:00 - Implementing PERCENTILE_DISC function in SQL Server
9:01 to 11:15 - Deference between PERCENTILE_DISC and PERCENTILE_CONT function

Playlist - https://www.youtube.com/watch?v=Nhcgs0bNshE&list=PLdnPqkBptCEITvVQtcOmKUgA7xT6Fqixc
------------------------------------------------------------------------------------------
CUME_DIST() - https://youtu.be/Nhcgs0bNshE
PERCENT_RANK() - https://youtu.be/Kd6coeQN8Y4
FIRST_VALUE() - https://youtu.be/nCl01TIseZs
LAST_VALUE() - https://youtu.be/NnMH-TU-BU4
LEAD() - https://youtu.be/_DlXcVW_axA
LAG() - https://youtu.be/1yt2f4k5DAM
PERCENTILE_CONT() - https://youtu.be/0VwRl5geLOs
PERCENTILE_DISC() - https://youtu.be/KJborDiUvNk
------------------------------------------------------------------------------------------

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'

Thanks for watching this video.