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