1 Answer
- Newest
- Most votes
- Most comments
0
Here's an alternative using a window function:
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
answered a year ago
Relevant content
- asked 4 years ago
- asked 5 years ago
- asked 2 years ago
- asked 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago