I cloned it in postgres on a porting project awhile back.
However, it is not only Oracle specific, but in most cases it is EVIL since people abuse it to get out of creating reference tables.
How to do without subqueries
- (drewk)
- (18)
- April 21, 2005, 12:02:47 AM EDT
SELECT DISTINCT t1.* FROM t1, t2 ...?
- (FuManChu)
- April 21, 2005, 01:26:10 AM EDT
I don't understand your description
- (ben_tilly)
- (16)
- April 21, 2005, 02:21:36 AM EDT
Reply from Drew
- (Meerkat)
- (15)
- April 21, 2005, 09:34:14 AM EDT
Re: Reply from Drew
- (SpiceWare)
- (6)
- April 21, 2005, 09:59:22 AM EDT
DECODE is Oracle-specific.
-NT
- (ben_tilly)
- (5)
- April 21, 2005, 08:37:47 PM EDT
It is, but it is easy to clone
- (tuberculosis)
- April 22, 2005, 09:29:35 AM EDT
Are you sure? I checked MySQL before posting
- (SpiceWare)
- (3)
- April 22, 2005, 09:54:09 AM EDT
They may have added it but it is not standard
- (ben_tilly)
- April 22, 2005, 11:16:56 AM EDT
Seems to be specific to MaxDB
- (JayMehaffey)
- (1)
- April 22, 2005, 11:35:10 AM EDT
That's rather confusing
- (SpiceWare)
- April 22, 2005, 12:14:55 PM EDT
One solution
- (JayMehaffey)
- (1)
- April 21, 2005, 10:25:00 AM EDT
FWIW this was the best I saw for our needs
- (drewk)
- April 21, 2005, 08:49:39 PM EDT
Untested, googling for supported syntax
- (ben_tilly)
- April 21, 2005, 10:32:29 AM EDT
Re: Reply from Drew
- (dws)
- (4)
- April 21, 2005, 08:17:36 PM EDT
You're ordering by the wrong thing
- (ben_tilly)
- (3)
- April 21, 2005, 08:36:52 PM EDT
Where do you see me ordering by count(*) ?
-NT
- (dws)
- (2)
- April 22, 2005, 12:38:23 PM EDT
You weren't, clarification
- (ben_tilly)
- (1)
- April 22, 2005, 02:08:36 PM EDT
Re: You weren't, clarification
- (dws)
- April 22, 2005, 04:32:31 PM EDT