RE: COUNT (*)

Posted in 1997

Sujit Pal — 2 Dec 1997 21:28:09 -0500 — source: Informix-list mailing list archive (1991-1998)

Edward Do: isql dbname 2>/dev/null <<! SELECT COUNT(*) FROM table! This will get rid of the 1 rows retrieved line. HTH Sujit Pal ---------- From: Edward Bidinotto[SMTP:edbid@cobe.com] Sent: Tuesday, November 25, 1997 11:58 AM To: informix-list@rmy.emory.edu Subject: COUNT (*) To all" When you do isql dbname <<! select count(*) from table! it comes back with the count and also 1 row(s) retrieved. Is there any way to eliminate the 1 row retrieved within a script? Tks Ed edbid @ cobe.com