Re: rows in select

Posted in 1996

sinyem@pc.jaring.my — 4 Nov 1996 11:23:29 -0500 — source: Informix-list mailing list archive (1991-1998)

On Mon, 4 Nov 1996, manoj@future.dsc.dalsys.com (Manoj Shroff) wrote: >Hi All, > > Is there any way to find out how many rows were selected >in Informix v7 (online). > > You means counting selected rows from a table ???? Try the following: SELECT COUNT(*) INTO num_of_row FROM table_name Regards =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= _/_/_/_/ _/ _/ _/_/_/ Richard Wellis Sinyem / / / / / Company: Microlink Consultancy Sdn Bhd _/ _/ _/ _/ _/ Tel: 082-415785 Fax: 082-428264 / / / / / _/_/_/_/ _/ _/ _/_/_/ E-Mail: sinyem@pc.jaring.my (home) / / / / / _/ _/ _/ _/ _/ _/ senyem@hq.microln.com.my (office) / / / / / / _/ _/ _/_/_/_/_/ _/_/_/ WWW: http://www.microln.com.my =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=