COMBINA

Updated 2024-03-01 22:12:05.397000

Syntax

SELECT [westclintech].[wct].[COMBINA] (
   <@Number, int,>
  ,<@Number_chosen, int,>)

Use the scalar function COMBINA to calculate the number of combinations with repetition of n things taken r at a time. The formula is:

C=\frac{\left(n+r-1\right)!}{r!\left(n-1\right)!

Number to be taken. @Number_chosen must be of type int or of a type that implicitly converts to int.

Number of things. @Number must be of type int or of a type that implicitly converts to int.

float

@Number >= @Number_chosen >= 0.

Example #1

SELECT wct.COMBINA(4, 2) as COMBINA;

This produces the following result.

{"columns":[{"field":"COMBINA","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"}],"rows":[{"COMBINA":"10"}]}