Lines Matching refs:round
152 # Test the abs() and round() functions.
180 catchsql {SELECT round(a,b,c) FROM t1}
181 } {1 {wrong number of arguments to function round()}}
183 catchsql {SELECT round(b,2) FROM t1 ORDER BY b}
186 catchsql {SELECT round(b,0) FROM t1 ORDER BY a}
189 catchsql {SELECT round(c) FROM t1 ORDER BY a}
192 catchsql {SELECT round(c,a) FROM t1 ORDER BY a}
195 catchsql {SELECT 'x' || round(c,a) || 'y' FROM t1 ORDER BY a}
198 catchsql {SELECT round() FROM t1 ORDER BY a}
199 } {1 {wrong number of arguments to function round()}}
201 execsql {SELECT coalesce(round(a,2),'nil') FROM t2}
204 execsql {SELECT round(t1,2) FROM tbl1}
254 SELECT sum(a), count(a), round(avg(a),2), min(a), max(a), count(*) FROM t2;