liabi4hao

分类

刷题笔记(2) 题解(10)

/ 注册

全部文章（共7篇）

题解 | #计算总和#

select order_num, sum(item_price*quantity) as total_price from OrderItems group by order_num having sum(quantity*item_price)>=...

Mysql 面试刷题

2022-03-09

0 577

题解 | #返回订单数量总和不小于100的所有订单的订单号#

SELECT order_num FROM OrderItems where quantity >= 100 GROUP BY order_num ORDER BY order_num ; 分析关键词：having 用法： where---过滤过滤...

Mysql 面试刷题

2022-03-08

0 415

题解 | #每个供应商成本最低的产品#

SELECT vend_id, MIN(prod_price) AS cheapest_item FROM Products GROUP BY vend_id ORDER BY cheapest_item ; 分析题目关键词：每个供应商成本最低的产品、从...

Mysql 面试刷题

2022-03-08

0 358

题解 | #返回 2020 年 1 月的所有订单的订单号和订单日期#

关键词: 时间格式化使用mysql提供的几种时间处理函数即可 select order_num,order_date from Orders where YEAR(order_date) = 2020 and MONTH(order_date) =...

Mysql 面试刷题

2022-03-07

3 464

题解 | #顾客登录名#

代码： select cust_id,cust_name, upper(concat(substring(cust_name,1,2),substring(cust_city,1,3))) as user_login from Customers ; ...

Mysql 面试刷题

2022-03-07

0 265

题解 | #别名#

select vend_id, vend_name as vname, vend_address as vaddress, vend_city as vcity from Vendors order by vend_name ; 额外收获提交代码...

Mysql 题解面试刷题

2022-03-07

1 740

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

分析关键词： like 用法：[字符] like '%_[]字符' %表示任何字符出现任意次数 _表示单个字符 []表示一个字符集题解代码，如下 SELECT prod_name, prod_desc FROM Products WHERE prod_des...

Mysql sql必知必会面试刷题

2022-03-07

1 415