对牛可弹琴

题解

/ 注册

全部文章 / 题解（共36篇）

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

```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

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

```public class Solution { public int FirstNotRepeatingChar(String str) { if (str.length() == 0) { return -1; } ...

Java

2022-02-21

0 244

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

```public class Solution { public int GetNumberOfK(int [] array , int k) { // 排除数组是空的情况 if (array.length == 0) { retu...

Java

2022-02-21

0 234

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

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

Mysql Java

2022-02-21

0 278

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

```import java.util.ArrayList; import java.util.List; public class Solution { public int[] multiply(int[] A) { // 初始化B int[] B ...

Java

2022-02-21

0 249

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

```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

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

```SELECT answer_date, author_id, count( issue_id ) author_cnt FROM answer_tb GROUP BY answer_date, author_id HAVING count( issue_id ) >=...

Mysql

2022-02-19

0 251

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

```WITH t AS ( SELECT b.char_len, CASE WHEN a.author_level IN ( 1, 2 ) THEN "1-2级" WHEN a.author_level IN ( 3, 4 ) THEN "3-4级" EL...

Mysql

2022-02-19

0 300