# 档案日期2015的2

## 题目描述：

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 number should be the next consecutive integer value. In other ...

## 题目描述：

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

## 题目描述：

Given a list of non negative integers, arrange them such that they form the largest number.

For example, given [3, 30, 34, 5, 9], the largest formed number is 9534330.

Note: The result may be very large, so you ...

## 题目描述：

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 作者是 在线疯狂 发布于 2015年1月12日 在 LeetCode.

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.
```+-------------+---------+