冷凡社长

分类

题解(2)

/ 注册

TA的专栏 0篇文章 0人订阅

0篇文章 0人学习

全部文章（共133篇）

题解 | #别名#

select vend_id, vend_name as vname, vend_address as vaddress, vend_city as vcity from Vendors order by vend_name 知识点：列别名的使用易错点：vcity 在最后边，位置也会导致错误

Mysql

2022-08-12

2 258

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

select prod_name , prod_desc from Products where prod_desc like "%toy%carrots%" order by prod_name 主要是like%的使用，通配符，这样的需求在实际中遇到的还不多，都不太熟悉这个...

Mysql

2022-08-12

1 268

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

select prod_name , prod_desc from Products where prod_desc like "%toy%" and prod_desc like "%carrots%" order by prod_name 就是两个like

Mysql

2022-08-12

3 233

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

select prod_name , prod_desc from Products where prod_desc not like "%toy%" order by prod_name 知识点 not的使用，not like

Mysql

2022-08-12

2 213

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

select prod_name , prod_desc from Products where prod_desc like "%toy%" 知识点：like的用法，%为通配符，表示0个或多个字符。

Mysql

2022-08-12

4 219

题解 | #纠错2#

SELECT vend_name FROM Vendors WHERE vend_country = 'USA' AND vend_state = 'CA' ORDER BY vend_name 将order by 放到语句最后即可。知识点，考察sql关键词的...

Mysql

2022-08-12

26 326

题解 | #返回所有价格在 3美元到 6美元之间#

select prod_name,prod_price from Products where prod_price >= 3 and prod_price<=6 order by prod_price 和69题重复了～

Mysql

2022-08-12

2 278

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

select order_num,prod_id,quantity from OrderItems where prod_id in ('BR01','BR02','BR03') and quantity >= 100 这个题简单思考了下，就是...

Mysql

2022-08-12

1 323

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

select vend_name from Vendors where vend_country = 'USA' and vend_state = 'CA' 知识点：1、多列筛选使用 and链接2、筛选为字符串使用单双引号都可以，没有区别3、注意这里的字符串要大...

Mysql

2022-08-12

1 298

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

select order_num from OrderItems group by order_num having sum(quantity) >= 100 知识点：分组后使用having进行结果集的筛选

Mysql

2022-08-12

0 202