1 Answer
- Newest
- Most votes
- Most comments
0
【以下的回答经过翻译处理】 以下是使用窗口函数的另一种替代方案:
SELECT barcode, sequence, d FROM (
SELECT barcode, sequence, d, rank() OVER (PARTITION BY barcode
ORDER BY length(sequence) desc) AS r
FROM "db1"."barcodes"
) as windw
WHERE windw.r = 1
Relevant content
- asked a year ago
- asked a year ago
- asked a year ago
- asked 10 months ago
- AWS OFFICIALUpdated 2 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a month ago
- AWS OFFICIALUpdated 2 years ago