对牛可弹琴

分类

题解(36)

/ 注册

全部文章（共34篇）

题解 | #商品交易(网易校招笔试真题)#

```WITH t AS ( SELECT *, TIMESTAMPDIFF( SECOND, in_time, out_time ) AS subtime, date( in_time ) days FROM tb_user_log WHERE YEAR ( in_t...

Mysql

2022-02-18

0 373

题解 | #商品交易(网易校招笔试真题)#

WITH t AS ( SELECT CASE WHEN TIMESTAMPDIFF( SECOND, t1.start_time, t1.end_time ) >= t2.duration THEN 100 ELSE TIMESTAMPDIFF( SECOND, t1.start...

Mysql

2022-02-18

0 276

题解 | #商品交易(网易校招笔试真题)#

SELECT g.*, t1.total total FROM goods g INNER JOIN ( SELECT t.goods_id, SUM( t.count ) total FROM goods g LEFT JOIN trans t ON g.id = t.goods_id GROUP...

Mysql

2022-02-14

0 258

题解 | #查找薪水记录超过15次的员工号emp_no以及其对应的记录次数t#

```SELECT o.id id, o.is_group_buy is_group_buy, IFNULL(NULL,c.`name`) NAME FROM order_info o LEFT JOIN client c ON o.client_id = c.id WHERE use...

Mysql

2022-02-14

0 291