sel000003.test 465 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13
# sel000003
#
# Versions
# --------
#   3.22
#   3.23
#
# Description
# -----------
# This test is just a simple select.
# Testing count() function and GROUP BY clause.
#

14 15 16
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (name CHAR(20) NOT NULL PRIMARY KEY, score SMALLINT NOT NULL, KEY(score));
INSERT INTO t1 VALUES ('Sasha', 20), ('Matt', 20), ('Monty', 10), ('David', 10), ('Tim', 10), ('Jeremy', 10);
17
SELECT COUNT(*) as n, score FROM t1 GROUP BY score;
18
drop table t1;