Re: [SQL] Please help: How to determine largest of two numbers in a query?
От | Adam Maddock |
---|---|
Тема | Re: [SQL] Please help: How to determine largest of two numbers in a query? |
Дата | |
Msg-id | Pine.LNX.3.96.981202204004.4082A-100000@apu.maddock.net обсуждение исходный текст |
Ответ на | Please help: How to determine largest of two numbers in a query? (Greg Youngblood <YoungblG@houstoncellular.com>) |
Список | pgsql-sql |
Greg - This may not be the slickest way to do it, but it works... SELECT yyyymmdd, key, value1 AS value FROM greg WHERE value1 > value2 UNION SELECT yyyymmdd, key, value2 AS value FROM greg WHERE value2 > value1; I hope this helps. :-) Blessings, Adam ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Adam Maddock http://Adam.Maddock.com Detroit, MI adam@maddock.com "BE IMITATORS of God, therefore, as dearly loved children..." (Ephesians 5:1) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ On Wed, 2 Dec 1998, Greg Youngblood wrote: > I have a table with the following structure: > yyyymmdd int4 > key char(16) > value1 int4 > value2 int4 > > with the following sample data: > yyyymmdd key value1 value2 > 19981201 hello 32 16 > 19981201 bye 29 64 > 19981202 hello 16 20 > 19981202 bye 23 13 > > What I need is to select the greatest between value1 and value2, so the > answer would be: > yyyymmdd key value > 19981201 hello 32 > 19981201 bye 64 > 19981202 hello 20 > 19981202 bye 23 > > I can do this via ODBC using access by creating a column which is defined as > IF(value1>value2,value1,value2) but that doesn't work in psql. > > How can I make this work in psql? > > Thanks > Greg >
В списке pgsql-sql по дате отправления: