注意:以下翻译的准确性尚未经过验证。这是使用 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 |