IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / Where do you see me ordering by count(*) ?
Post #204,436
by dws
4/22/05 12:38:23 PM
Reply
New Where do you see me ordering by count(*) ?
Post #204,487
by ben_tilly
4/22/05 2:08:36 PM
Reply
New You weren't, clarification
He wanted it sorted by whether any tickets were open. You weren't sorting by that, you were sorting by ordernum. Hence the title of my post.

I suggested that you could fix that to get something closer to what he wanted by sorting on count(*), but it doesn't support exactly the sort that I think he would eventually decide that he wants.

Cheers,
Ben
I have come to believe that idealism without discipline is a quick road to disaster, while discipline without idealism is pointless. -- Aaron Ward (my brother)
Post #204,514
by dws
4/22/05 4:32:31 PM
Reply
New Re: You weren't, clarification
Damn. You're right. I skipped over the ordering requirement.
     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

Check out Elimidate.. but not right after a meal, OK?
92 ms