编辑代码

CREATE DATABASE test;
use test;
CREATE TABLE TABLE6 (
    Stkcd VARCHAR(10),
    Trddt DATE,
    Opnprc DECIMAL(10, 2),
    Clsprc DECIMAL(10, 2),
    Dnshrtrd BIGINT
);
INSERT INTO TABLE6 (Stkcd, Trddt, Opnprc, Clsprc, Dnshrtrd)
    VALUES ('603897', '2019-01-02', 23.01, 22.81, 2176373);

INSERT INTO TABLE6 (Stkcd, Trddt, Opnprc, Clsprc, Dnshrtrd)
    VALUES ('603898', '2019-01-02', 15.33, 15.33, 852951);

INSERT INTO TABLE6 (Stkcd, Trddt, Opnprc, Clsprc, Dnshrtrd)
    VALUES ('603899', '2019-01-02', 30.15, 28.86, 3435768);

INSERT INTO TABLE6 (Stkcd, Trddt, Opnprc, Clsprc, Dnshrtrd)
VALUES ('603900', '2019-01-02', 11.88, 11.82, 629531);

INSERT INTO TABLE6 (Stkcd, Trddt, Opnprc, Clsprc, Dnshrtrd)
VALUES ('603901', '2019-01-02', 6.59, 6.62, 968100);

INSERT INTO TABLE6 (Stkcd, Trddt, Opnprc, Clsprc, Dnshrtrd)
VALUES ('603903', '2019-01-02', 20.84, 20.15, 1865700);

INSERT INTO TABLE6 (Stkcd, Trddt, Opnprc, Clsprc, Dnshrtrd)
VALUES ('603906', '2019-01-02', 8.65, 8.63, 1106160);

INSERT INTO TABLE6 (Stkcd, Trddt, Opnprc, Clsprc, Dnshrtrd)
VALUES ('603908', '2019-01-02', 24.38, 24.51, 963600);

INSERT INTO TABLE6 (Stkcd, Trddt, Opnprc, Clsprc, Dnshrtrd)
VALUES ('603909', '2019-01-02', 25.52, 25.7, 1089096);

INSERT INTO TABLE6 (Stkcd, Trddt, Opnprc, Clsprc, Dnshrtrd)
VALUES ('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;