编辑代码

CREATE DATABASE test;
use test;
CREATE TABLE TABLE6 (
    Stkcd VARCHAR(10),
    Trddt DATE,
    Opnprc DECIMAL(10, 2),
    Clsprc DECIMAL(10, 2),
    Dnshrtrd INT
);
INSERT INTO TABLE6 (Stkcd, Trddt, Opnprc, Clsprc, Dnshrtrd) VALUES
('603897', '2019-01-02', 23.01, 22.81, 2176373),
('603898', '2019-01-02', 15.33, 15.33, 852951),
('603899', '2019-01-02', 30.15, 28.86, 3435768),
('603900', '2019-01-02', 11.88, 11.82, 629531),
('603901', '2019-01-02', 6.59, 6.62, 968100),
('603903', '2019-01-02', 20.84, 20.15, 1865700),
('603906', '2019-01-02', 8.65, 8.63, 1106160),
('603908', '2019-01-02', 24.38, 24.51, 963600),
('603909', '2019-01-02', 25.52, 25.7, 1089096),
('603912', '2019-01-02', 13.32, 13.7, 4097856);
SELECT Dnshrtrd
FROM TABLE6
WHERE Stkcd = '603903';
SELECT Stkcd, Opnprc
FROM TABLE6;
SELECT Stkcd, Trddt
FROM TABLE6
WHERE Clsprc BETWEEN 10 AND 20
ORDER BY Dnshrtrd DESC;