Skip to content

Instantly share code, notes, and snippets.

@waveform80

waveform80/gist:4124157

Created November 21, 2012 10:29
Show Gist options
  • Save waveform80/4124157 to your computer and use it in GitHub Desktop.
Save waveform80/4124157 to your computer and use it in GitHub Desktop.
Download ZIP
LEAST alternative
Raw
gistfile1.sql
CASE WHEN ContractPrice < DiscountPrice
THEN
CASE WHEN ContractPrice < ListPrice THEN ContractPrice ELSE ListPrice END
ELSE
CASE WHEN DiscountPrice < ListPrice THEN DiscountPrice ELSE ListPrice END
END
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment