注意:以下翻译的准确性尚未经过验证。这是使用 AIP ↗ 从原始英文文本进行的机器翻译。
支持于: 批处理
选择每个排序分区中的顶部行。
变换类别: 聚合
参数值:
airline}airport, DESCENDING), (miles, ASCENDING)]输入:
| airline | airport | miles |
|---|---|---|
| foundry airways | JFK | 1002345 |
| foundry airways | LHR | 2221324 |
| new air | SFO | 21356673 |
| new air | JFK | 12323456 |
| foundry airways | LHR | 12542352 |
| new air | JFK | 12232355 |
输出:
| airline | airport | miles |
|---|---|---|
| foundry airways | LHR | 2221324 |
| new air | SFO | 21356673 |
参数值:
airline, DESCENDING), (airport, DESCENDING), (miles, ASCENDING)]输入:
| airline | airport | miles |
|---|---|---|
| foundry airways | JFK | 1002345 |
| foundry airways | LHR | 2221324 |
| new air | SFO | 21356673 |
| new air | JFK | 12323456 |
| foundry airways | LHR | 12542352 |
| new air | JFK | 12232355 |
输出:
| airline | airport | miles |
|---|---|---|
| new air | SFO | 21356673 |
| new air | JFK | 12232355 |
参数值:
输入:
| airline | airport | miles |
|---|---|---|
| foundry airways | JFK | 1002345 |
| foundry airways | LHR | 2221324 |
| new air | SFO | 21356673 |
| new air | JFK | 12323456 |
| foundry airways | LHR | 12542352 |
| new air | JFK | 12232355 |
输出:
| airline | airport | miles |
|---|---|---|
| foundry airways | JFK | 1002345 |