LeetCode
飘渺时光
这个作者很懒,什么都没留下…
展开
-
【LeetCode之MySQL】172.Second Highest Salary
题目: Write a SQL query to get the second highest salary from the Employee table. +----+--------+ | Id | Salary | +----+--------+ | 1 | 100 | | 2 | 200 | | 3 | 300 | +----+--------+ For...原创 2018-12-29 11:45:48 · 184 阅读 · 0 评论 -
【LeetCode之MySQL】175. Combine Two Tables
问题: Table: Person +-------------+---------+ | Column Name | Type | +-------------+---------+ | PersonId | int | | FirstName | varchar | | LastName | varchar | +-------------+--------...原创 2018-12-29 20:13:36 · 190 阅读 · 0 评论 -
【LeetCode之MySQL】7. Reverse Integer
Given a 32-bit signed integer, reverse digits of an integer. Example 1: Input: 123 Output: 321 Example 2: Input: -123 Output: -321 Example 3: Input: 120 Output: 21 Note: Assume we are dea...原创 2018-12-29 20:40:49 · 128 阅读 · 0 评论 -
【LeetCode】182. Duplicate Emails
Write a SQL query to find all duplicate emails in a table named Person. +----+---------+ | Id | Email | +----+---------+ | 1 | a@b.com | | 2 | c@d.com | | 3 | a@b.com | +----+---------+ For e...原创 2018-12-31 14:34:17 · 271 阅读 · 0 评论 -
【LeetCode】184. Department Highest Salary
The Employee table holds all employees. Every employee has an Id, a salary, and there is also a column for the department Id. +----+-------+--------+--------------+ | Id | Name | Salary | Departmen...原创 2019-01-01 13:48:32 · 192 阅读 · 0 评论 -
【LeetCode】627. Swap Salary
别人的解决方法让我 十分惊讶,没想到还能这样写: update salary set sex = CHAR(ASCII('f') ^ ASCII('m') ^ ASCII(sex)); 题目: Given a table salary, such as the one below, that has m=male and f=female values. Swap all f and m v...原创 2019-01-01 14:18:37 · 174 阅读 · 0 评论 -
【LeetCode】326. Power of Three
Easy 228882FavoriteShare Given an integer, write a function to determine if it is a power of three. Example 1: Input: 27 Output: true Example 2: Input: 0 Output: false Example 3: Input:...原创 2019-02-03 17:49:51 · 270 阅读 · 0 评论