我不打朋友圈

题解

/ 注册

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

题解 | #年终奖#

import java.util.*; public class Bonus { public int getMost(int[][] board) { int row = board.length; int col = board[0].length; int[][] bonus = new in...

Java

2021-12-16

1 590

题解 | #最大差值#

import java.util.*; public class Solution { /** * 代码中的类名、方法名、参数名已经指定，请勿修改，直接返回方法规定的值即可 * * * @param A int整型一维数组 * @param n int整型 * @return int整型 / pub...

Java

2021-12-16

0 593

题解 | #游戏海报#

import java.io.BufferedReader; import java.io.InputStreamReader; import java.io.IOException; public class Main{ public static void main(String[] args)...

Java

2021-12-15

0 318

题解 | #出现三次以上相同积分的情况#

select number from grade group by number having count(number) >=3 SELECT number FROM grade GROUP BY number HAVING COUNT(number) >=3;

Mysql

2021-12-15

0 253

题解 | #将所有to_date为9999-01-01的全部更新为NULL#

update titles_test set to_date = null ,from_date = '2001-01-01' where to_date = '9999-01-01' update titles_test set to_date = null , from_date = '2001...

Mysql

2021-12-15

0 222

题解 | #删除emp_no重复的记录，只保留最小的id对应的记录。#

delete from titles_test where id not in (select * from (select min(id) from titles_test group by emp_no) as a) delete from titles_test where id not in...

Mysql

2021-12-15

0 303

题解 | #获取当前薪水第二多的员工的emp_no以及其对应的薪水salary#

select emp_no,salary from salaries where salary = (select distinct(salary) from salaries order by salary desc limit 1,1) order by emp_no SELECT emp_no...

Mysql

2021-12-15

0 214

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

select emp_no,count(salary) t from salaries group by emp_no having t>15; select emp_no,count(salary) t from salaries group by emp_no having t>15...

Mysql

2021-12-15

1 237

题解 | #分贝壳#

import java.io.BufferedReader; import java.io.InputStreamReader; import java.io.IOException; public class Main{ public static void main(String[] args)...

Java

2021-12-15

0 404

题解 | #美妙的约会#

import java.io.BufferedReader; import java.io.InputStreamReader; import java.io.IOException; import java.util.ArrayList; import java.util.LinkedList; ...

Java

2021-12-15

0 412