sql重合関数は何がありますか?

2933 ワード

                       ,    SELECT   GROUP BY      ,SQL SERVER            ?        :
1. AVG , 。
:select prd_no,avg(qty) from sales group by prd_no

2. COUNT 。
:select count(prd_no) from sales

3. MAX 。
:select prd_no,max(qty) from sales group by prd_no

4. MIN 。
:select prd_no,min(qty) from sales group by prd_no

5. SUM , , 。
:select prd_no,sum(qty) from sales group by prd_no

6. COUNT_BIG , COUNT COUNT_BIG bigint , COUNT int 。
:select count_big(prd_no) from sales

7. GROUPING , CUBE ROLLUP , 1. CUBE ROLLUP , 0.
:select prd_no,sum(qty),grouping(prd_no) from sales group by prd_no with rollup

8. BINARY_CHECKSUM , 。
:select prd_no,binary_checksum(qty) from sales group by prd_no

9. CHECKSUM_AGG , 。
:select prd_no,checksum_agg(binary_checksum(*)) from sales group by prd_no

10. CHECKSUM , 。

11. STDEV 。
:select stdev(prd_no) from sales

12. STDEVP 。
:select stdevp(prd_no) from sales

13. VAR 。
:select var(prd_no) from sales

14. VARP 。
:select varp(prd_no) from sales