人生苦短,但求成长
人生苦短,但求成长
全部文章
题解
归档
标签
去牛客网
登录
/
注册
人生苦短,但求成长的博客
全部文章
/ 题解
(共86篇)
题解 | #确定已售出产品项 BR01 的总数#
select sum(quantity) as items_ordered from OrderItems where prod_id ='BR01'
Mysql
2022-03-12
3
0
题解 | #返回 2020 年 1 月的所有订单的订单号和订单日期#
select order_num,order_date from Orders where month(order_date) = 1 and year(order_date) = 2020 ord...
Mysql
2022-03-12
15
430
题解 | #顾客登录名#
select cust_id,cust_name,upper(concat(substr(cust_name,1,2),substr(cust_city,1,3))) as user_login from Customers
Mysql
2022-03-12
3
637
题解 | #打折#
select prod_id,prod_price,prod_price * 0.9 as sale_price from Products
Mysql
2022-03-12
2
505
题解 | #别名#
select vend_id,vend_name as vname,vend_address as vaddress,vend_city as vcity from Vendors order by...
Mysql
2022-03-12
4
549
题解 | #检索产品名称和描述(四)#
select prod_name, prod_desc from Products where prod_desc like '%toy%carrots%...
Mysql
2022-03-12
12
850
题解 | #检索产品名称和描述(三)#
select prod_name, prod_desc from Products where prod_desc like '%toy%' a...
Mysql
2022-03-12
3
536
题解 | #检索产品名称和描述(二)#
select prod_name, prod_desc from Products where prod_desc not like '%toy...
Mysql
2022-03-12
2
473
题解 | #检索产品名称和描述(一)#
select prod_name, prod_desc from Products where prod_desc like '%toy%'
Mysql
2022-03-12
40
1412
题解 | #纠错2#
SELECT vend_name FROM Vendors WHERE vend_country = 'USA' AND vend_state = 'CA' ORDER BY&...
Mysql
2022-03-12
2
418
首页
上一页
1
2
3
4
5
6
7
8
9
下一页
末页