CREATE VIEW vw_odate AS SELECT
*
FROM
orders
WHERE
odate > '2016-12-05'
ORDER BY
ocount DESC
LIMIT 2
4. 创建视图vw_odate:查询2016-12-05之后销售数量最高的两笔销售信息
最新推荐文章于 2022-06-11 12:39:22 发布
CREATE VIEW vw_odate AS SELECT
*
FROM
orders
WHERE
odate > '2016-12-05'
ORDER BY
ocount DESC
LIMIT 2