SQL66. 检查SQL语句
描述
vend_name |
海底捞 |
小龙坎 |
大龙燚 |
SELECT vend_name, FROM Vendors ORDER vend_name DESC;
vend_name |
海底捞 |
小龙坎 |
大龙燚 |
示例1
输入:
DROP TABLE IF EXISTS `Vendors`; CREATE TABLE IF NOT EXISTS `Vendors` ( `vend_name` VARCHAR(255) NOT NULL COMMENT 'vend名称' ); INSERT INTO `Vendors` VALUES ('海底捞'), ('小龙坎'), ('大龙燚');
输出:
海底捞 小龙坎 大龙燚
Mysql 解法, 执行用时: 38ms, 内存消耗: 6556KB, 提交时间: 2022-03-04
select vend_name from Vendors order by vend_name Desc;
Mysql 解法, 执行用时: 39ms, 内存消耗: 6432KB, 提交时间: 2022-03-03
select vend_name from Vendors order by vend_name desc
Mysql 解法, 执行用时: 39ms, 内存消耗: 6436KB, 提交时间: 2022-03-07
SELECT vend_name FROM Vendors ORDER by vend_name desc;
Mysql 解法, 执行用时: 39ms, 内存消耗: 6480KB, 提交时间: 2022-03-04
select vend_name from Vendors Order by 1 desc
Mysql 解法, 执行用时: 39ms, 内存消耗: 6572KB, 提交时间: 2022-03-04
select * from Vendors order by vend_name desc;