MySQL 学习6

最新推荐文章于 2024-07-13 10:38:18 发布

Sun_Rose_

最新推荐文章于 2024-07-13 10:38:18 发布

阅读量157

点赞数

分类专栏：自学文章标签： mysql

本文链接：https://blog.csdn.net/Sun_Rose_/article/details/114049490

版权

自学专栏收录该内容

16 篇文章 0 订阅

订阅专栏

通过这十道题学到了很多导入数据,更加了解了数据库的存储读取等操作,也知道了怎么从中筛选出要用的数据
当多个表时连用 inner join on
当表名中有空格时可以用[]或者``引用表名
如第一题三个表
SELECT MarketData.*,
OperatingData.INDIC_NAME_EN,
OperatingData.VALUE,
IncomeStatement.N_INCOME,
IncomeStatement.T_COGS,
IncomeStatement.T_REVENUE
FROM (
SELECT TICKER_SYMBOL,
END_DATE,
CLOSE_PRICE
FROM market data
WHERE TICKER_SYMBOL IN (‘600383’,‘600048’) ) MarketData
LEFT JOIN – operating data
(SELECT TICKER_SYMBOL,
INDIC_NAME_EN,
END_DATE,
VALUE
FROM company operating
WHERE TICKER_SYMBOL IN (‘600383’,‘600048’) ) OperatingData
ON MarketData.TICKER_SYMBOL = OperatingData.TICKER_SYMBOL
AND MarketData.END_DATE = OperatingData.END_DATE
LEFT JOIN – income statement
(SELECT DISTINCT TICKER_SYMBOL,
END_DATE,
T_REVENUE,
T_COGS,
N_INCOME
FROM income statement
WHERE TICKER_SYMBOL IN (‘600383’,‘600048’) ) IncomeStatement
ON MarketData.TICKER_SYMBOL = IncomeStatement.TICKER_SYMBOL
AND MarketData.END_DATE = IncomeStatement.END_DATE
ORDER BY MarketData.TICKER_SYMBOL, MarketData.END_DATE