RosettaCodeData/Task/Integer-comparison/DuckDB/integer-comparison.duckdb

9 lines
283 B
Text
Raw Permalink Normal View History

2025-08-11 18:05:26 -07:00
select a
|| if ( a < b, ' is less than ',
if ( a = b, ' is equal to ',
if ( a > b, ' is greater than ',
' is incomparable to ')))
|| b as comparison
from read_csv_auto('/dev/stdin', header=false, sep=' ',
columns= {'a': 'INTEGER', 'b': 'INTEGER'});