苏格拉底有话说
苏格拉底有话说
全部文章
[LeetCo...
Python教程(2)
VBA教程(3)
数据分析第三方库(11)
概率论与数理统计(1)
正则表达式(1)
网络爬虫与信息提取(4)
归档
标签
去牛客网
登录
/
注册
Eric_ldh
Never too late to learn
全部文章
/ [LeetCode]-[DataBase]
（共10篇）
[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. +----+-------+--------+...
2019-07-15
0
296
[LeetCode#180]Consecutive Numbers
Write a SQL query to find all numbers that appear at least three times consecutively. +----+-----+ | Id | Num | +----+-----+ | 1 | 1 | | 2 | 1 ...
2019-07-02
0
451
[LeetCode#175]Combine Two Tables
Table: Person +-------------+---------+ | Column Name | Type | +-------------+---------+ | PersonId | int | | FirstName | varchar | | Las...
2019-07-01
0
403
[SQL]数据分析SQL笔试题
SQL笔试题 1、请简单写出left join和join的用法区别（可举例说明）； join用于把来自两个或多个表的行结合起来，基于这些表之间的共同字段； left join 关键字从左表（table1）返回所有的行，即使右表（table2）中没有匹配。如果右表中没有匹配，则结果为NULL。 ...
2019-06-25
2
1113
[SQL]连续三天有销售额
店铺 销售日期 销售额 A 2017-10-11 300 A 2017-10-12 200 B 2017-10-11 400 B 2017-10-12 200 A 2017-10-13 ...
2019-06-25
0
832
[LeetCode#183]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...
2019-06-24
0
379
[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@...
2019-06-24
0
407
[LeetCode#181]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. +----+-----...
2019-06-23
0
394
[LeetCode#178]Rank Scores
Write a SQL query to rank scores. If there is a tie between two scores, both should have the same ranking. Note that after a tie, the next ranking num...
2019-06-19
0
430
[LeetCode#177]Nth Highest Salary
Write a SQL query to get the nth highest salary from the Employee table. +----+--------+ | Id | Salary | +----+--------+ | 1 | 100 | | 2 | 200 ...
2019-06-12
0
308
牛客博客，记录你的成长
京公网安备 11010502036488号