编辑代码

CREATE DATABASE test;
use test;
-- (1) 查询 "TABLE4" 表中所有数据
SELECT * FROM TABLE4;
-- (2) 查询 "TABLE4" 表中的所有股票简称和对应的股票代码
SELECT STOCK, SYMBOL FROM TABLE4;
-- (3) 查询价格在30~100之间的股票名称、代码和价格，并按价格降序排序
SELECT STOCK, SYMBOL, PRICE FROM TABLE4 
WHERE PRICE BETWEEN 30 AND 100 
ORDER BY PRICE DESC;
-- 1. 查询表中所有数据
SELECT * FROM stock_info;
-- 2. 查询股票简称和股票代码
SELECT STOCK, SYMBOL FROM stock_info;
-- 3. 查询股票简称、代码和价格
SELECT STOCK, SYMBOL, PRICE FROM stock_info;
-- 4. 查询特定省份的股票信息（示例：广东省）
SELECT * FROM stock_info WHERE PROVINCE = '广东省';
-- 5. 查询A类股票信息
SELECT * FROM stock_info WHERE SHARETYPE = 'A';
-- 6. 查询价格高于50的股票
SELECT * FROM stock_info WHERE PRICE > 50;
-- 7. 查询股票简称以"B"结尾的股票（B股）
SELECT * FROM stock_info WHERE STOCK LIKE '%B';
SELECT * FROM stock_info;
SELECT SYMBOL FROM stock_info;
SELECT DISTINCT SHARETYPE FROM stock_info;
SELECT STOCK, SYMBOL FROM stock_info;
SELECT * FROM stock_info;
-- 1. 查询所有A类股票
SELECT * FROM stock_info WHERE SHARETYPE = 'A';
-- 2. 查询价格大于50的股票
SELECT STOCK, PRICE FROM stock_info WHERE PRICE > 50;
-- 3. 查询非A类股票
SELECT * FROM stock_info WHERE SHARETYPE <> 'A';
-- 4. 查询价格小于等于30的股票
SELECT STOCK, SYMBOL FROM stock_info WHERE PRICE <= 30;
-- 5. 查询广东省的股票
SELECT * FROM stock_info WHERE PROVINCE = '广东省';
-- 6. 查询股票简称以"B"结尾的(B股)
SELECT * FROM stock_info WHERE STOCK LIKE '%B';
-- 7. 查询价格在20-100之间的股票
SELECT * FROM stock_info WHERE PRICE >= 20 AND PRICE <= 100;
-- 1. 查询所有A股
SELECT * FROM stock_info WHERE SHARETYPE='A';
-- 2. 查询所有股价小于50的股票
SELECT * FROM stock_info WHERE PRICE < 50;
SELECT STOCK FROM stock_info WHERE SHARETYPE ='A';
SELECT * FROM stock_info WHERE SYMBOL LIKE '0%';
SELECT * FROM stock_info WHERE SYMBOL LIKE '%1';
SELECT * FROM stock_info WHERE SYMBOL LIKE '%9%';
SELECT * FROM stock_info WHERE SYMBOL NOT LIKE '%9%';
SELECT * FROM stock_info WHERE SHARETYPE='A' AND PROVINCE='广东省';
SELECT * FROM stock_info WHERE PRICE=7.11 OR SHARETYPE='B';
SELECT * FROM stock_info WHERE SHARETYPE='B' AND (PROVINCE='广东省' OR PROVINCE='浙江省');
SELECT * FROM stock_info WHERE SHARETYPE='A' AND PROVINCE='广东省';
SELECT * FROM stock_info WHERE PRICE NOT BETWEEN 0 AND 10;
SELECT * FROM stock_info ORDER BY SHARETYPE;
SELECT * FROM stock_info ORDER BY SHARETYPE,PRICE;
SELECT * FROM stock_info ORDER BY PRICE DESC;
SELECT * FROM stock_info ORDER BY SHARETYPE ASC, PRICE DESC;
SELECT * FROM stock_info ORDER BY PRICE DESC;
SELECT * FROM TABLE4;
SELECT STOCK, SYMBOL, PRICE FROM TABLE4 WHERE PRICE BETWEEN 30 AND 100 ORDER BY PRICE DESC;
-- (1) 查询证券代码为603903的日个股交易股数
SELECT DnsIntrd FROM TABLE6 WHERE Siked = '603903';

-- (2) 查询所有的证券代码和对应的日开盘价
SELECT Siked, Oppure FROM TABLE6;

-- (3) 查询日收盘价在10~20之间的证券代码和交易日期，并按日个股交易股数降序排序
SELECT Siked, Tedit FROM TABLE6 
WHERE Clspec BETWEEN 10 AND 20 
ORDER BY DnsIntrd DESC;