风飞飞飞

分类

题解(57)

/ 注册

全部文章（共57篇）

题解 |SQL17 #检索产品名称和描述（二）#

分析关键词：like 用法：[字符] like '%_[]字符' %表示任何字符出现任意次数 _表示单个字符 []表示一个字符集代码 select prod_name,prod_desc from Products where prod_desc not like '%toy%' order...

Mysql

2022-03-04

18 771

题解 | SQL16#检索产品名称和描述（一）#

分析关键词：like 用法：[字符] like '%_[]字符' %表示任何字符出现任意次数 _表示单个字符 []表示一个字符集代码 select prod_name,prod_desc from Products where prod_desc like '%toy%'

Mysql

2022-03-04

26 1027

题解 | SQL15#纠错2#

分析关键词：where,order 用法：select [列名] from [表名] where 判断条件 order by .. 思路：where的用法在order之前代码 SELECT vend_name FROM Vendors WHERE vend_country = 'USA' A...

Mysql

2022-03-04

7 751

题解 | 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

7 663

题解 | 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 556

题解 | 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

13 1270

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

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

Mysql

2022-03-04

0 416

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

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

Mysql

2022-03-04

12 831

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

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

Mysql

2022-03-04

1 388

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

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

Mysql

2022-03-04

3 438