Re: order by clause in stored procedure

Posted in 2000

Isidre PONS ROCA — Thu, 20 Jul 2000 08:38:16 +0200 — source: Informix-list mailing list archive (1991-1998)

En sansaw@hotmail.com va escriure el dia 19 Jul 2000, a les 16:22: > > > Help! > > Does anyone know how to specify the 'ORDER BY DESC' in the select > statement in a stored procedure? When I use 'ORDER BY' it just sorts in > ascending order. I need to sort the table data in descending order. I > can use 'ORDER BY DESC' in Informix-4gl. Can't I use in stored > procedure? > > Thanks in advance. > > > Sansaw. > > > Sent via Deja.com http://www.deja.com/ > Before you buy. ORDER BY column_name DESC, column_name_2, column_mane_3 DESC... ? --------------------------------------- Isidre PONS ROCA BASE - Gesti' d'Ingressos Locals (Diputacio de Tarragona) Servei de Sistemes d'Informacio Av President Lluis Companys 12-C 43005 - Tarragona SPAIN Tel # +34 977 236731 Fax # +34 977 227302 http://www.altanet.org ipons@dtgna.altanet.org ---------------------------------------