编辑代码

CREATE DATABASE test;
use test;
create table table6
(
    Stkcd varchar(6),
    Trddt varchar(20),
    Opnprc decimal(10,2),
    Clsprc decimal(10,2),
    Dnshrtrd decimal(20,0)
);
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;
SELECT * FROM (
    SELECT Stkcd, Dnshrtrd FROM table6
) AS tmp_table ORDER BY Dnshrtrd DESC;