MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
-- 欄
CREATE TABLE col (
id INT NOT NULL AUTO_INCREMENT,
min_num FLOAT,
max_num FLOAT,
PRIMARY KEY (id)
);
INSERT INTO col
VALUES (null, 1, 1.9);
INSERT INTO col
VALUES (null, 2, 2.9);
INSERT INTO col
VALUES (null, 3, 3.9);
SELECT * FROM col;


id
min_num
max_num


1
1
1.9

2
2
2.9

3
3
3.9


-- 列
CREATE TABLE row (
id INT NOT NULL AUTO_INCREMENT,
value FLOAT,
PRIMARY KEY (id)
);
INSERT INTO row
VALUES (null, 50);
INSERT INTO row
VALUES (null, 60);
SELECT * FROM row;


id
value


1
50

2
60


-- 資料
CREATE TABLE data (
id INT NOT NULL AUTO_INCREMENT,
col_id INT NOT NULL,
row_id INT NOT NULL,
data VARCHAR(255),
PRIMARY KEY (id)
);
INSERT INTO data
VALUES (null, 1, 1, '1356');
INSERT INTO data
VALUES (null, 1, 2, '1768');
INSERT INTO data
VALUES (null, 1, 3, '1920');
INSERT INTO data
VALUES (null, 2, 1, '1546');
INSERT INTO data
VALUES (null, 2, 2, '1911');
INSERT INTO data
VALUES (null, 2, 3, '2034');
SELECT CONCAT(col.min_num, '~', col.max_num) as col_value, row.value as row_value, data.data
FROM col, row, data
WHERE col.id = data.col_id
AND row.id = data.row_id
-- 尋找欄=1~1.9、列=60
AND (1.3 BETWEEN col.min_num AND col.max_num)
AND row.value = 60
;


col_value
row_value
data


1~1.9
60
1768