RE: Sorting Problem

Posted in 2006

Mike Badar — Tue, 1 Aug 2006 09:46:27 -0600 — source: Usenet: comp.databases.informix

> -----Original Message----- > From: informix-list-bounces@iiug.org > [mailto:informix-list-bounces@iiug.org] On Behalf Of bozon > Sent: Tuesday, August 01, 2006 5:53 AM > To: informix-list@iiug.org > Subject: Re: Sorting Problem > > Select Select id[1,1], id[2, N] + 0 id from table order by 1 desc, 2 > desc > > I would think. Luckily I waited till 7:50 my time to look at it. You should write a book on SQL! I have a directory where I keep all of your cool SQL code; and no, I'm not trying to win favors for my next SQL question. Mike Badar ESRI Professional Services Denver Region 1 International Court Broomfield, CO 80021-3200 303-449-7779 mbadar@esri.com www.esri.com

↪ replying to Mike Badar

bozon — 1 Aug 2006 10:09:15 -0700 — source: Usenet: comp.databases.informix

Thanks. I try hard. Mike Badar wrote: > > -----Original Message----- > > From: informix-list-bounces@iiug.org > > [mailto:informix-list-bounces@iiug.org] On Behalf Of bozon > > Sent: Tuesday, August 01, 2006 5:53 AM > > To: informix-list@iiug.org > > Subject: Re: Sorting Problem > > > > Select Select id[1,1], id[2, N] + 0 id from table order by 1 desc, 2 > > desc > > > > I would think. Luckily I waited till 7:50 my time to look at it. > > > You should write a book on SQL! I have a directory where I keep all of > your cool SQL code; and no, I'm not trying to win favors for my next SQL > question. > > Mike Badar > ESRI Professional Services > Denver Region > 1 International Court > Broomfield, CO 80021-3200 > 303-449-7779 > mbadar@esri.com > www.esri.com