Skip to content

Instantly share code, notes, and snippets.

@ezhov-da

ezhov-da/sql-teradata-Least.sql

Last active March 10, 2019 12:18
Show Gist options
  • Save ezhov-da/cd209c6d688517eef19d62b503c83c9c to your computer and use it in GitHub Desktop.
Save ezhov-da/cd209c6d688517eef19d62b503c83c9c to your computer and use it in GitHub Desktop.
Download ZIP
teradata least
Raw
sql-teradata-Least.sql
select
cast(252 as decimal(18,6)) as one
,cast(9602250000.000000 as decimal(18,6)) as two
,td_sysfnlib.least(one, two) as resultLeastOne
,td_sysfnlib.least(cast(252 as decimal(18,6)), cast(9602250000.000000 as decimal(18,6))) as resultLeastTwo
,td_sysfnlib.least(252, 9602250000.000000) as resultLeastThree
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment