blob: 3b225690e29640385ccbc38beee4d9b6d66ed456 [file] [log] [blame]
SELECT max(t2.col_bigint), t2.col_chr
FROM tbl_bigint_l t1, tbl_bigint_r t2
WHERE t1.col_bigint = t2.col_bigint OR ( t1.col_bigint IS NULL AND t2.col_bigint IS NULL )
group by t2.col_chr
order by t2.col_chr;