1.
SELECT customernumber, customername, creditlimit
FROM customers
ORDER BY creditlimit DESC
LIMIT 5;
以升序排列creditlimit 获取前五的数据
MySQL LIMIT子句
最新推荐文章于 2022-08-12 18:43:51 发布
1.
SELECT customernumber, customername, creditlimit
FROM customers
ORDER BY creditlimit DESC
LIMIT 5;
以升序排列creditlimit 获取前五的数据