Re: SQL: select by count & value
From: Daniel Roy <danielroy10_at_hotmail.com>
Date: 28 Feb 2003 05:52:12 -0800
Message-ID: <1b061893.0302280552.757f9a3c_at_posting.google.com>
Date: 28 Feb 2003 05:52:12 -0800
Message-ID: <1b061893.0302280552.757f9a3c_at_posting.google.com>
Try this (not tested):
select state_id, state from states where state in ('Illinois','California') order by decode(state,'Illinois',1,'California',2);
Daniel Received on Fri Feb 28 2003 - 14:52:12 CET