You're ordering by the wrong thing

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #204,377 by ben_tilly 4/21/05 8:36:52 PM Reply	You're ordering by the wrong thing Yes, you can order by the count(), but you're now subordering by the number of escalations and may want a different sort. That is why I did all of the CASE garbage in my solution. 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,436 by dws 4/22/05 12:38:23 PM Reply	Where do you see me ordering by count(*) ?
Post #204,487 by ben_tilly 4/22/05 2:08:36 PM Reply	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	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

I don't see how this has anything remotely to do with football.
43 ms