学习生1

分类

/ 注册

全部文章（共175篇）

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

select prod_name, prod_desc from Products where prod_desc like '%toy%';

2024-11-25

0 55

题解 | #纠错2#

SELECT vend_name FROM Vendors WHERE vend_country = 'USA' AND vend_state = 'CA';

2024-11-25

0 67

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

select prod_name, prod_price from Products where prod_price>=3 and prod_price<=6 order by prod_price;

2024-11-25

0 48

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

select order_num, prod_id, quantity from OrderItems where quantity>=100;

2024-11-25

0 48

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

select vend_name from Vendors where vend_country='USA' and vend_state='CA';

2024-11-25

0 38

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

select distinct order_num from OrderItems where quantity>=100;

2024-11-25

0 63

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

select prod_name, prod_price from Products where prod_price between 3 and 6;

2024-11-25

0 53

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

select prod_id, prod_name from Products where prod_price>=9;

2024-11-25

0 59

题解 | #字符函数正则匹配2#

select id, comment from comment_detail where comment like '是%' or comment like '求%';

2024-11-25

0 84

题解 | #字符函数正则匹配1#

#输出 comment中包含 "是"，或"试"，或"报名"的 id，comment列，查询返回结果按照id升序排列 select id, comment from comment_detail where ...

2024-11-25

0 117