immjc

2017年10月31日

摘要： How would you print just the 10th line of a file? For example, assume that file.txt has the following content: Your script should output the tenth lin 阅读全文

posted @ 2017-10-31 15:59 immjc 阅读(129) 评论(0) 推荐(0)

[LeetCode] 1-bit and 2-bit Characters

摘要： We have two special characters. The first character can be represented by one bit 0. The second character can be represented by two bits (10 or 11). N 阅读全文

posted @ 2017-10-31 15:46 immjc 阅读(491) 评论(0) 推荐(0)

[TCP/IP] HTTP概述

摘要： HTTP 请求访问文本或图像等资源的一端称为客户端提供资源响应的一端称为服务器端。请求报文是由请求方法、请求URI、协议版本、可选的请求首部字段、内容实体响应报文是由协议版本、状态码、原因短语、可选响应首部字段、实体 HTTP是一种无状态协议。 HTTP协议自身不具备保存之前发送过的请求或响应阅读全文

posted @ 2017-10-31 15:18 immjc 阅读(169) 评论(0) 推荐(0)

2017年10月24日

[LeetCode] Second Highest Salary

摘要： Write a SQL query to get the second highest salary from the Employee table. For example, given the above Employee table, the query should return 200 a 阅读全文

posted @ 2017-10-24 11:52 immjc 阅读(145) 评论(0) 推荐(0)

[LeetCode] Delete Duplicate Emails

摘要： Write a SQL query to delete all duplicate email entries in a table named Person, keeping only unique emails based on its smallest Id. For example, aft 阅读全文

posted @ 2017-10-24 11:46 immjc 阅读(146) 评论(0) 推荐(0)

[LeetCode] Classes More Than 5 Students

摘要： There is a table courses with columns: student and class Please list out all classes which have more than or equal to 5 students. For example, the tab 阅读全文

posted @ 2017-10-24 11:34 immjc 阅读(493) 评论(0) 推荐(0)

[LeetCode] Rising Temperature

摘要： Given a Weather table, write a SQL query to find all dates' Ids with higher temperature compared to its previous (yesterday's) dates. + + + + | Id(INT 阅读全文

posted @ 2017-10-24 11:20 immjc 阅读(145) 评论(0) 推荐(0)

[LeetCode] Customers Who Never Order

摘要： Suppose that a website contains two tables, the Customers table and the Orders table. Write a SQL query to find all customers who never order anything 阅读全文

posted @ 2017-10-24 09:38 immjc 阅读(124) 评论(0) 推荐(0)

2017年10月23日

[LeetCode] Employees Earning More Than Their Managers

摘要： The Employee table holds all employees including their managers. Every employee has an Id, and there is also a column for the manager Id. Given the Em 阅读全文

posted @ 2017-10-23 22:17 immjc 阅读(206) 评论(0) 推荐(0)

[LeetCode] Combine Two Tables

摘要： Table: Person Table: Address Write a SQL query for a report that provides the following information for each person in the Person table, regardless if 阅读全文

posted @ 2017-10-23 21:03 immjc 阅读(121) 评论(0) 推荐(0)

Don't live up to your ambition and sorry for your sufferings.

公告