风飞飞飞

分类

题解(57)

/ 注册

全部文章（共64篇）

题解 | SQL14#返回所有价格在 3美元到 6美元之间的产品的名称和价格#

分析关键词：where 用法：select [列名] from [表名] where 判断条件 order by .. 判断条件：between [下届] and [上届] 代码 select prod_name,prod_price from Products where prod_price ...

Mysql

2022-03-04

5 652

题解 | SQL13#检索并列出已订购产品的清单#

分析关键词：where 用法：select [列名] from [表名] where 判断条件 order by .. 判断条件：where [列名] in(元素1，元素2，...) 代码 select order_num,prod_id,quantity from OrderItems wher...

Mysql

2022-03-04

0 554

题解 | SQL12#检索供应商名称#

分析关键词：where 用法：select [列名] from [表名] where 判断条件 order by .. 判断条件：逻辑运算符---and，or 代码 select vend_name from Vendors where vend_state='CA' and vend_count...

Mysql

2022-03-04

12 1249

题解 | SQL11#返回更多的产品#

分析关键词：where，distinct(去重）用法：select distinct [列名] from [表名] where 判断条件 order by .. 代码 select distinct order_num from OrderItems where quantity>=100

Mysql

2022-03-04

0 410

题解 | SQL10#返回产品并且按照价格排序#

分析关键词：where 用法：select [列名] from [表名] where 判断条件 order by .. 判断条件：between [下届] and [上届] (包含上下界）代码 select prod_name,prod_price from Products where pro...

Mysql

2022-03-04

9 810

题解 | SQL9#返回更高价格的产品#

分析关键词：where 用法：select [列名] from [表名] where 判断条件 order by .. 判断条件：相等（=），大于（>）,小于（<）,... 代码 select prod_id,prod_name from Products where prod_pri...

Mysql

2022-03-04

1 384

题解 | SQL8#返回固定价格的产品#

分析关键词：where 用法：select [列名] from [表名] where 判断条件 order by ... 代码 select prod_id,prod_name from Products where prod_price=9.49

Mysql

2022-03-04

2 429

题解 | SQL7#检查SQL语句#

分析关键词：select,order 用法： select [列名1],[列名2],...,[列名n] from order by [列名1]asc/desc,[列名2]asc/desc,... 代码 SELECT vend_name FROM Vendors ORDER by vend_n...

Mysql

2022-03-04

1 506

题解 |SQL6 #按照数量和价格排序#

分析关键词：order 多行排序:order by [列名1],[列名2],... 排序规则：asc---升序，desc---降序代码 select quantity,item_price from OrderItems order by quantity desc,item_price des...

Mysql

2022-03-04

0 397

题解 | SQL5#对顾客ID和日期排序#

分析关键词：order 多列排序：order by 列名1,[列名2],[列名3],... 代码 select cust_id,order_num from Orders order by cust_id asc,order_date desc

Mysql

2022-03-04

5 612