CREATE TABLE NUMBERS ( value INT )
INSERT INTO NUMBERS VALUES (1); INSERT INTO NUMBERS VALUES (2); INSERT INTO NUMBERS VALUES (3); INSERT INTO NUMBERS VALUES (4);
SELECT AVG(val) FROM NUMBERS;
INSERT INTO NUMBERS VALUES (1); INSERT INTO NUMBERS VALUES (1); INSERT INTO NUMBERS VALUES (1); INSERT INTO NUMBERS VALUES (1);
SELECT TOP 1 val FROM NUMBERS GROUP BY val ORDER BY COUNT(*) DESC
以上就是SQL Server 中的均值和众数的详细内容,更多请关注php中文网其它相关文章!
已抢187137个
抢已抢67526个
抢已抢353825个
抢已抢668568个
抢已抢124017个
抢已抢26306个
抢