对牛可弹琴

分类

题解(36)

/ 注册

全部文章（共34篇）

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

```WITH t AS ( SELECT *, SUBSTRING_INDEX( PROFILE, ',',- 1 ) gender FROM user_submit ) SELECT gender, count( gender ) number FROM t GROUP BY gende...

Mysql

2022-02-24

0 292

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

```WITH t AS ( SELECT a.device_id, a.university, a.answer_cnt, b.question_id FROM user_profile a LEFT JOIN question_practice_detail b O...

Mysql

2022-02-24

0 225

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

```WITH t AS ( SELECT a.device_id, a.university, a.answer_cnt, b.question_id FROM user_profile a LEFT JOIN question_practice_detail b O...

Mysql

2022-02-24

0 227

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

```WITH t AS ( SELECT *, CASE WHEN age > 24 THEN "25岁及以上" WHEN 20 <= age <= 24 THEN "20-24岁" ELSE "其他" END age_cnt FROM user_profile ) SELECT...

Mysql

2022-02-24

0 213

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

```WITH t AS ( SELECT a.device_id, b.question_id, b.result, b.date FROM user_profile a LEFT JOIN question_practice_detail b ON a.device...

Mysql

2022-02-22

0 237

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

```WITH t AS ( SELECT b.*, a.result, a.date, CASE WHEN result = "right" THEN 1 ELSE 0 END flag FROM user_profile b LEFT JOI...

Mysql

2022-02-22

0 231

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

```import java.util.Arrays; public class Solution { public int MoreThanHalfNum_Solution(int [] array) { if (array.length==1){ ...

Mysql Java

2022-02-21

0 278

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

```public class Solution { public boolean Find(int target, int [][] array) { int rows = array.length; int columns = array[0].lengt...

Mysql

2022-02-21

0 210

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

```import java.util.HashSet; public class Solution{ public int duplicate (int[] numbers) { // write code here int length = number...

Mysql

2022-02-20

0 214

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

```WITH t AS ( SELECT a.author_id, a.issue_id, b.issue_type FROM answer_tb a LEFT JOIN issue_tb b ON a.issue_id = b.issue_id ) SELECT ...

Mysql

2022-02-19

0 283