ROUND 函数,为四舍五入的, 下面是一个例子: SQL> SELECT ROUND(1.56), ROUND(1.56,1), ROUND(12.34, -2) FROM dual; ROUND(1.56) ROUND(1.56,1) ROUND(12.34,-2) ----------- ------------- --------------- 2 1.6 0
如有一表table1,字段code int,我有10条记录,其中code=1的有2条,code=2的有3条,code=3的有5条,我如何用一SQL语句把code相同值对应的记录统计出来?
select code ,count(*) as quantity from table1 group by code