🏷️

#SQL

共 8 篇博文

已为您筛选出所有包含「#SQL」标签的技术文章与算法真题

算法与 LeetCode 专题 · 核心算法·2018-1-5 1·2 分钟

LeetCode Rising Temperature

Problem Given a Weather table, write a SQL query to find all dates' Ids with higher temperature compared to its previous (yesterday's) dates. For example, retur...

#LeetCode #SQL

🧮 Algo数据结构与算法

算法与 LeetCode 专题 · 核心算法·2017-12-29·2 分钟

LeetCode Delete Duplicate Emails

Problem 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, after...

#LeetCode #SQL

🧮 Algo数据结构与算法

算法与 LeetCode 专题 · 核心算法·2017-12-21·2 分钟

LeetCode Nth Highest Salary

Problem 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 = 2...

#LeetCode #SQL

🧮 Algo数据结构与算法

算法与 LeetCode 专题 · 核心算法·2017-12-21·2 分钟

LeetCode Employees Earning More Than Their Managers

Problem 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 Empl...

#LeetCode #SQL

🧮 Algo数据结构与算法

算法与 LeetCode 专题 · 核心算法·2017-12-21·2 分钟

LeetCode Duplicate Emails

Problem Write a SQL query to find all duplicate emails in a table named Person. For example, your query should return the following for the above table: 找到重复的Em...

#LeetCode #SQL

🧮 Algo数据结构与算法

算法与 LeetCode 专题 · 核心算法·2017-12-21·3 分钟

LeetCode Customers Who Never Order

Problem 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....

#LeetCode #SQL

🧮 Algo数据结构与算法

算法与 LeetCode 专题 · 核心算法·2017-12-20·2 分钟

LeetCode Second Highest Salary

Problem 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 as...

#LeetCode #SQL

🧮 Algo数据结构与算法

算法与 LeetCode 专题 · 核心算法·2017-12-20·3 分钟

LeetCode Combine Two Tables

Problem 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 t...

#LeetCode #SQL

🧮 Algo数据结构与算法

🎉已全部呈现所有 8 篇博文（可使用页面右上角或快捷键 / 搜索精准定位）