Grandyang

2016年4月4日

[CareerCup] 15.2 Renting Apartment II 租房之二

摘要： Write a SQL query to get a list of all buildings and the number of open requests (Requests in which status equals 'Open'). -- TABLE Apartments -- TABL 阅读全文

posted @ 2016-04-04 08:44 Grandyang 阅读(390) 评论(0) 推荐(0) 编辑

[LeetCode] 340. Longest Substring with At Most K Distinct Characters 最多有K个不同字符的最长子串

摘要： Given a string, find the length of the longest substring T that contains at most k distinct characters. Example 1: Input: s = "eceba", k = 2 Output: 3 阅读全文

posted @ 2016-04-04 08:22 Grandyang 阅读(26895) 评论(7) 推荐(2) 编辑

2016年4月3日

[CareerCup] 15.1 Renting Apartment 租房

摘要： Write a SQL query to get a list of tenants who are renting more than one apartment. -- TABLE Apartments -- TABLE Buildings -- TABLE Tenants -- TABLE C 阅读全文

posted @ 2016-04-03 08:32 Grandyang 阅读(589) 评论(0) 推荐(0) 编辑

[LeetCode] Nth Highest Salary 第N高薪水

摘要： Write a SQL query to get the nth highest salary from the Employee table. For example, given the above Employee table, the nth highest salary where n = 阅读全文

posted @ 2016-04-03 05:43 Grandyang 阅读(10369) 评论(0) 推荐(1) 编辑

[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 second highest salary is 阅读全文

posted @ 2016-04-03 05:00 Grandyang 阅读(11301) 评论(7) 推荐(1) 编辑

[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 @ 2016-04-03 04:09 Grandyang 阅读(6304) 评论(0) 推荐(1) 编辑

2016年4月2日

SQL Left Join, Right Join, Inner Join, and Natural Join 各种Join小结

摘要：在SQL语言中，存在着各种Join，有Left Join, Right Join, Inner Join, and Natural Join等，对于初学者来说肯定一头雾水，都是神马跟神马啊，它们之间到底有着怎样的区别和联系呢，我们先用一张图片来说明：上面这张图很好的阐释了Left Join， Ri 阅读全文

posted @ 2016-04-02 09:33 Grandyang 阅读(11257) 评论(1) 推荐(0) 编辑

2016年4月1日

MySQL Command 常见命令

摘要： More Information Check: http://blog.csdn.net/ithomer/article/details/5131863 阅读全文

posted @ 2016-04-01 03:24 Grandyang 阅读(3497) 评论(0) 推荐(0) 编辑

2016年3月31日

[LeetCode] 339. Nested List Weight Sum 嵌套链表权重和

摘要： Given a nested list of integers, return the sum of all integers in the list weighted by their depth. Each element is either an integer, or a list -- w 阅读全文

posted @ 2016-03-31 10:57 Grandyang 阅读(17346) 评论(1) 推荐(1) 编辑

2016年3月30日

[LeetCode] 325. Maximum Size Subarray Sum Equals k 最大子数组之和为k

摘要： Given an array nums and a target value k, find the maximum length of a subarray that sums to k. If there isn't one, return 0 instead. Note:The sum of 阅读全文

posted @ 2016-03-30 12:14 Grandyang 阅读(21192) 评论(8) 推荐(0) 编辑

2016年3月29日

[LeetCode] 254. Factor Combinations 因子组合

摘要： Numbers can be regarded as product of its factors. For example, 8 = 2 x 2 x 2; = 2 x 4. Write a function that takes an integer n and return all possib 阅读全文

posted @ 2016-03-29 13:55 Grandyang 阅读(14327) 评论(5) 推荐(0) 编辑

VTK GetScalarPointer() and GetScalarComponentAsFloat() not work

摘要： I am using VTK 5.10.1 with VS 2010, and the following example does not work on my machine: http://www.vtk.org/Wiki/VTK/Examples/Cxx/ImageData/IterateI 阅读全文

posted @ 2016-03-29 01:07 Grandyang 阅读(2049) 评论(0) 推荐(0) 编辑

2016年3月28日

[LeetCode] 255. Verify Preorder Sequence in Binary Search Tree 验证二叉搜索树的先序序列

摘要： Given an array of numbers, verify whether it is the correct preorder traversal sequence of a binary search tree. You may assume each number in the seq 阅读全文

posted @ 2016-03-28 05:55 Grandyang 阅读(12845) 评论(2) 推荐(0) 编辑

2016年3月27日

[LeetCode] 291. Word Pattern II 词语模式之二

摘要： Given a pattern and a string str, find if strfollows the same pattern. Here follow means a full match, such that there is a bijection between a letter 阅读全文

posted @ 2016-03-27 15:14 Grandyang 阅读(12857) 评论(10) 推荐(1) 编辑

2016年3月26日

[LeetCode] 265. Paint House II 粉刷房子之二

摘要： There are a row of n houses, each house can be painted with one of the k colors. The cost of painting each house with a certain color is different. Yo 阅读全文

posted @ 2016-03-26 14:26 Grandyang 阅读(16220) 评论(5) 推荐(0) 编辑

2016年3月25日

[LeetCode] 256. Paint House 粉刷房子

摘要： There are a row of n houses, each house can be painted with one of the three colors: red, blue or green. The cost of painting each house with a certai 阅读全文

posted @ 2016-03-25 14:30 Grandyang 阅读(18821) 评论(7) 推荐(0) 编辑

2016年3月24日

[LeetCode] 267. Palindrome Permutation II 回文全排列之二

摘要： Given a string s, return all the palindromic permutations (without duplicates) of it. Return an empty list if no palindromic permutation could be form 阅读全文

posted @ 2016-03-24 13:51 Grandyang 阅读(12458) 评论(0) 推荐(0) 编辑

2016年3月23日

[LeetCode] 277. Find the Celebrity 寻找名人

摘要： Suppose you are at a party with n people (labeled from 0 to n - 1) and among them, there may exist one celebrity. The definition of a celebrity is tha 阅读全文

posted @ 2016-03-23 13:00 Grandyang 阅读(21570) 评论(4) 推荐(1) 编辑

2016年3月22日

[LeetCode] 285. Inorder Successor in BST 二叉搜索树中的中序后继节点

摘要： Given a binary search tree and a node in it, find the in-order successor of that node in the BST. The successor of a node p is the node with the small 阅读全文

posted @ 2016-03-22 13:49 Grandyang 阅读(20260) 评论(9) 推荐(0) 编辑

2016年3月21日

[LeetCode] 308. Range Sum Query 2D - Mutable 二维区域和检索 - 可变

摘要： Given a 2D matrix matrix, find the sum of the elements inside the rectangle defined by its upper left corner (row1, col1) and lower right corner (row2 阅读全文

posted @ 2016-03-21 03:36 Grandyang 阅读(18540) 评论(2) 推荐(0) 编辑

2016年3月20日

[LeetCode] Shortest Distance from All Buildings 建筑物的最短距离

摘要： You want to build a house on an empty land which reaches all buildings in the shortest amount of distance. You can only move up, down, left and right. 阅读全文

posted @ 2016-03-20 14:14 Grandyang 阅读(23132) 评论(10) 推荐(0) 编辑

2016年3月19日

[LeetCode] Counting Bits 计数位

摘要： Given a non negative integer number num. For every numbers i in the range 0 ≤ i ≤ num calculate the number of 1's in their binary representation and r 阅读全文

posted @ 2016-03-19 07:05 Grandyang 阅读(21293) 评论(4) 推荐(1) 编辑

2016年3月18日

[LeetCode] 296. Best Meeting Point 最佳开会地点

摘要： A group of two or more people wants to meet and minimize the total travel distance. You are given a 2D grid of values 0 or 1, where each 1 marks the h 阅读全文

posted @ 2016-03-18 10:28 Grandyang 阅读(17031) 评论(3) 推荐(0) 编辑

2016年3月17日

[LeetCode] 286. Walls and Gates 墙和门

摘要： You are given a m x n 2D grid initialized with these three possible values. Fill each empty room with the distance to its nearest gate. If it is impos 阅读全文

posted @ 2016-03-17 01:03 Grandyang 阅读(22938) 评论(7) 推荐(1) 编辑

2016年3月16日

[LeetCode] 311. Sparse Matrix Multiplication 稀疏矩阵相乘

摘要： Given two sparse matrices A and B, return the result of AB. You may assume that A's column number is equal to B's row number. Example: A = [ [ 1, 0, 0 阅读全文

posted @ 2016-03-16 12:26 Grandyang 阅读(25655) 评论(1) 推荐(0) 编辑

2016年3月15日

[LeetCode] 314. Binary Tree Vertical Order Traversal 二叉树的竖直遍历

摘要： Given a binary tree, return the vertical order traversal of its nodes' values. (ie, from top to bottom, column by column). If two nodes are in the sam 阅读全文

posted @ 2016-03-15 12:31 Grandyang 阅读(19619) 评论(10) 推荐(0) 编辑

2016年3月14日

[LeetCode] 337. House Robber III 打家劫舍之三

摘要： The thief has found himself a new place for his thievery again. There is only one entrance to this area, called the "root." Besides the root, each hou 阅读全文

posted @ 2016-03-14 11:32 Grandyang 阅读(23739) 评论(9) 推荐(2) 编辑

2016年3月13日

[LeetCode] Palindrome Pairs 回文对

摘要： Given a list of unique words. Find all pairs of distinct indices (i, j) in the given list, so that the concatenation of the two words, i.e. words[i] 阅读全文

posted @ 2016-03-13 15:00 Grandyang 阅读(22864) 评论(0) 推荐(2) 编辑

2016年3月12日

[LeetCode] 302. Smallest Rectangle Enclosing Black Pixels 包含黑像素的最小矩阵

摘要： An image is represented by a binary matrix with 0 as a white pixel and 1 as a black pixel. The black pixels are connected, i.e., there is only one bla 阅读全文

posted @ 2016-03-12 15:05 Grandyang 阅读(10920) 评论(9) 推荐(0) 编辑

2016年3月11日

[LeetCode] 271. Encode and Decode Strings 加码解码字符串

摘要： Design an algorithm to encode a list of strings to a string. The encoded string is then sent over the network and is decoded back to the original list 阅读全文

posted @ 2016-03-11 14:46 Grandyang 阅读(15385) 评论(7) 推荐(0) 编辑

2016年3月10日

[LeetCode] 320. Generalized Abbreviation 通用简写

摘要： Write a function to generate the generalized abbreviations of a word. Note: The order of the output does not matter. Example: Input: "word" Output: [" 阅读全文

posted @ 2016-03-10 13:29 Grandyang 阅读(13505) 评论(5) 推荐(1) 编辑

2016年3月9日

[LeetCode] 261. Graph Valid Tree 图验证树

摘要： Given n nodes labeled from 0 to n-1 and a list of undirected edges (each edge is a pair of nodes), write a function to check whether these edges make 阅读全文

posted @ 2016-03-09 13:56 Grandyang 阅读(30313) 评论(8) 推荐(0) 编辑

2016年3月8日

[LeetCode] 298. Binary Tree Longest Consecutive Sequence 二叉树最长连续序列

摘要： Given a binary tree, find the length of the longest consecutive sequence path. The path refers to any sequence of nodes from some starting node to any 阅读全文

posted @ 2016-03-08 05:14 Grandyang 阅读(16045) 评论(3) 推荐(0) 编辑

2016年3月7日

[LeetCode] 269. Alien Dictionary 另类字典

摘要： There is a new alien language which uses the latin alphabet. However, the order among letters are unknown to you. You receive a list of non-empty word 阅读全文

posted @ 2016-03-07 13:35 Grandyang 阅读(28914) 评论(16) 推荐(0) 编辑

2016年3月6日

[LeetCode] 272. Closest Binary Search Tree Value II 最近的二分搜索树的值之二

摘要： Given a non-empty binary search tree and a target value, find k values in the BST that are closest to the target. Note: Given target value is a floati 阅读全文

posted @ 2016-03-06 14:32 Grandyang 阅读(18498) 评论(3) 推荐(1) 编辑

2016年3月5日

[LeetCode] 253. Meeting Rooms II 会议室之二

摘要： Given an array of meeting time intervals consisting of start and end times [[s1,e1],[s2,e2],...] (si < ei), find the minimum number of conference room 阅读全文

posted @ 2016-03-05 13:58 Grandyang 阅读(55860) 评论(11) 推荐(1) 编辑

2016年3月4日

[LeetCode] 252. Meeting Rooms 会议室

摘要： Given an array of meeting time intervals consisting of start and end times [[s1,e1],[s2,e2],...] (si < ei), determine if a person could attend all mee 阅读全文

posted @ 2016-03-04 07:13 Grandyang 阅读(24876) 评论(6) 推荐(0) 编辑

2016年3月3日

[LeetCode] 270. Closest Binary Search Tree Value 最近的二分搜索树的值

摘要： Given a non-empty binary search tree and a target value, find the value in the BST that is closest to the target. Note: Given target value is a floati 阅读全文

posted @ 2016-03-03 06:59 Grandyang 阅读(15197) 评论(0) 推荐(1) 编辑

2016年3月2日

[LeetCode] 259. 3Sum Smaller 三数之和较小值

摘要： Given an array of n integers nums and a target, find the number of index triplets i, j, k with 0 <= i < j < k < n that satisfy the condition nums[i] + 阅读全文

posted @ 2016-03-02 15:16 Grandyang 阅读(16003) 评论(2) 推荐(1) 编辑

2016年3月1日

[LeetCode] 276. Paint Fence 粉刷篱笆

摘要： There is a fence with n posts, each post can be painted with one of the k colors. You have to paint all the posts such that no more than two adjacent 阅读全文

posted @ 2016-03-01 15:31 Grandyang 阅读(16215) 评论(2) 推荐(1) 编辑

仰天长啸仗剑红尘，冬去春来寒暑几更...

公告