[LeetCode]Nth Highest Salary

题目描述:

Write a SQL query to get the nth highest salary from the Employee table.

+----+--------+
| Id | Salary |
+----+--------+
| 1  | 100    |
| 2  | 200    |
| 3  | 300    |
+----+--------+

For example, given the above Employee table, the nth highest salary where n = 2 is ...

继续阅读

[LeetCode]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 example, given the above Employee table, the second highest salary is 200. If there is no ...

继续阅读

[LeetCode]Combine Two Tables

LeetCode在原有的算法(Algorithm)题目分类基础之上,推出了全新的数据库(Database)题目分类,旨在帮助开发者提高数据库的开发技能。

Database分类下的第一题叫做Combine Two Tables,非常简单,大家可以拿来练手。只需将SQL语句填写在答题区即可。

题目描述:

Table: Person

+-------------+---------+
| Column Name | Type    |
+-------------+---------+
| PersonId    | int     |
| FirstName   | varchar |
| LastName    | varchar |
+-------------+---------+

PersonId is the primary key column for this table.
Table: Address

+-------------+---------+
| Column Name | Type    |
+-------------+---------+
| AddressId ...

继续阅读

年度归档