blob: cef82ab25965e3ef877d50646ca07086543108d3 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
# sel000003
#
# Versions
# --------
# 3.22
# 3.23
#
# Description
# -----------
# This test is just a simple select.
# Testing count() function and GROUP BY clause.
#
DROP TABLE IF EXISTS t;
CREATE TABLE t (name CHAR(20) NOT NULL PRIMARY KEY, score SMALLINT NOT NULL, KEY(score));
INSERT INTO t VALUES ('Sasha', 20), ('Matt', 20), ('Monty', 10), ('David', 10), ('Tim', 10), ('Jeremy', 10);
@r/sel000003.result SELECT COUNT(*) as n, score FROM t GROUP BY score;
|
