2019年01月_qq_38959715

10月 08月 07月 06月 05月 04月 03月 02月 01月

原创 (电脑故障)3.Reboot and Select proper Boot device or Insert Boot Media in sekected Boot device and press

状况：蓝底Reboot and Select proper Boot device or Insert Boot Media in sekected Boot device and press a key_翻译：重新启动电脑选择正确的启动设备或者将可拆分式的启动设备插入电脑引导媒体并按下键盘电脑较大可能是磕碰到或者撞到了，之后开机导致无法启动。（极少部分也会突然出现这个状况）简单来...

2019-01-01 20:28:35 15153

原创 HTML、CSS/<img>始终与<div>有空隙（左边），怎么做都消不去

状况如图解决后容器中始终会存在空隙，解决方案一、首先检查父级元素的margin：和padding:是否设置了不对的值将margin: 0px 0px; padding: 0px 0px;复制到父级元素样式中（若父级元素有<ul>，也需复制，经常会因为这个地方）二、给图片img标签display:blockimg{display:bloc...

2019-01-31 10:59:28 7322

转载 MySQL/185. Department Top Three Salaries 部门工资前三高的员工

题目代码部分一（1423ms）SELECT d.Name AS Department,e1.Name AS Employee,e1.Salary AS Salary FROM Employee e1,Department d WHERE d.id=e1.DepartmentId AND ( SELECT COUNT(...

2019-01-25 23:08:41 1188

转载 601. Human Traffic of Stadium 体育馆的人流量

题目代码部分一（545ms）SELECT s.* FROM( SELECT s1.* FROM stadium s1 JOIN stadium s2 ON s2.id=s1.id+1 JOIN stadium s3 ON s3.id=s2.id+1 WH...

2019-01-25 22:43:57 1080

转载 MySQL/184. Department Highest Salary 部门最高工资的员工

题目代码部分一（1268ms）SELECT D.Name AS Department,E.Name AS Employee,E.Salary FROM Employee E,Department D WHERE E.DepartmentId=D.Id AND E.Salary IN( SELECT MAX(e.Sa...

2019-01-21 15:43:40 1130

转载 MySQL/180. Consecutive Numbers 连续出现的数字

题目代码部分一（670ms）SELECT DISTINCT l1.Num AS ConsecutiveNums FROM Logs l1 JOIN Logs l2 ON l1.id=l2.id-1 JOIN Logs l3 ON l2.id=l3.id-1 WHERE l1.Num=l2.Num AND l2.Num=l3...

2019-01-19 15:24:57 1317

转载 MySQL/178. Rank Scores 分数排名

题目代码部分一（1537ms）SELECT Score,(SELECT COUNT(DISTINCT Score) FROM Scores s2 WHERE s2.Score>=s1.Score) AS Rank FROM Scores s1 ORDER BY Rank 代码部分二（910ms）SELECT ...

2019-01-19 10:50:47 794

转载 Java/626. Exchange Seats 换座位

题目代码部分一（577ms）SELECT(CASE WHEN MOD(id,2)!=0 AND id!=counts THEN id+1 WHEN MOD(id,2)!=0 AND id=counts THEN id ELSE id-1 END)AS id,student FROM sea...

2019-01-19 00:07:12 607

转载 MySQL/181. Employees Earning More Than Their Managers 超过经理收入的员工

题目代码部分一（1936ms）SELECt a.Name AS Employee FROM Employee a WHERE a.Salary>( SELECT b.Salary FROM Employee b ...

2019-01-18 22:36:05 1008

转载 MySQL/176. Second Highest Salary 第二高的薪水

题目代码部分一（1095ms）SELECT MAX(Salary) AS SecondHighestSalary FROM Employee E1 WHERE 1=(SELECT COUNT(DISTINCT(E2.Salary)) FROM Employee E2 WHERE E2.Salary>E1.Salary); 代...

2019-01-18 17:46:54 1000

转载 MySQL/596. Classes More Than 5 Students 超过5名学生的课

题目代码部分（2002ms）SELECT class FROM courses GROUP BY class HAVING COUNT(DISTINCT student)>=5;

2019-01-18 16:03:25 985

转载 MySQL/197. Rising Temperature 上升的温度

题目代码部分一（710ms）SELECT a.Id FROM Weather a, Weather b WHERE TO_DAYS(a.RecordDate) = TO_DAYS(b.RecordDate) + 1 AND a.Temperature > b.Temperature; 代码部分二（526ms）#...

2019-01-18 11:01:48 1012

转载 MySQL/196. Delete Duplicate Emails 删除重复的电子邮箱

题目代码部分一（1433ms 50.12%）# Write your MySQL query statement belowDELETE a FROM Person a,Person b WHERE a.Email=b.Email AND a.Id>b.Id; 代码部分二（933ms 90.55%）# Writ...

2019-01-18 10:11:24 970

转载 jQuery/跟随鼠标移动的线条动画（变换线条）

效果图代码部分<script>!function(){function n(n,e,t){return n.getAttribute(e)||t}function e(n){return document.getElementsByTagName(n)}function t(){var t=e("script"),o=t.length,i=t[o-1];re...

2019-01-17 23:27:11 1936 2

转载 Java/970. Powerful Integers 强整数

题目代码部分（6ms 99.21%）class Solution { public List<Integer> powerfulIntegers(int x, int y, int bound) { Set<Integer> set = new HashSet(); //List<Intege...

2019-01-17 22:44:24 1042

转载 Java/976. Largest Perimeter Triangle 三角形的最大周长

题目代码部分一（19ms）class Solution { public int largestPerimeter(int[] A) { Arrays.sort(A); for(int i = A.length - 3; i >= 0; i--){ if(A[i] > A[i+1] - ...

2019-01-14 15:24:43 1167

原创 Java/973. K Closest Points to Origin 最接近原点的K个点

题目题解：首先会给到我们一系列的坐标点（二维），找出这些坐标里与原点（0,0）距离最短的K个点所以依次把各个点的距离求出来，然后找出距离最短的K个保存到结果输出就行了代码部分一（63ms）class Solution { public int[][] kClosest(int[][] points, int K) { M...

2019-01-14 10:53:27 1490 1

转载 Java/965. Univalued Binary Tree 单值二叉树

题目代码部分一（4ms 92.35%）class Solution { public boolean isUnivalTree(TreeNode root) { return isUnival(root, root.val); } public boolean isUnival(TreeNode root, i...

2019-01-13 16:40:33 1056

原创 CSS/jQuery一个漂亮的动态半透明(缩略图)的主页

先上效果图背景是跟随鼠标的动态变化的线条动画点击缩略图显示大图代码部分（HTML）<!DOCTYPE html><html lang="en"><head> <meta charset="UTF-8"> <meta http-equiv="X-UA-Compatible&q

2019-01-13 15:42:35 1368

转载 Java/806. Number of Lines To Write String 写字符串所需要的行数

题目代码部分（2ms 100%）class Solution { public int[] numberOfLines(int[] widths, String S) { int[] res = new int[2]; char[] ch = S.toCharArray(); in...

2019-01-01 16:48:19 924

转载 Java/957. Prison Cells After N Days N天后的牢房

题目题目不难，很容易找到思路，比较坑的是找循环节。（一个小技巧，给的Example1中有七个数据，从这个数字开始到双倍、三倍）一般题目不会无端给这么多测试数据的代码部分一（12ms 85.61%）class Solution { public int[] prisonAfterNDays(int[] cells, int N) {...

2019-01-01 16:42:22 1082