Re: Query question

Posted in 1995

Francis Small — 14 Dec 1995 00:07:04 GMT — source: Informix-list mailing list archive (1991-1998)

And we have a winner: SELECT COUNT(UNIQUE field) INTO row_count FROM table; A not-so-simple case of "read the manual". The user manual says "Do not specify a column name with the COUNT() function." The reference manual shows that you can use COUNT(DISTINCT field). Thanks to all that replied! Francis -- | . . . . . . . . . 1 . . . . . . . . . 2 . . . . . . . . . 3 . . . . . . . . Bums Francis Small - M/S 2LRS Rockies Hewlett-Packard Company Padres Microwave Instruments Div. GIANTS 1212 Valley House Dr. Rohnert Park CA, 94928 707 794 3305 fthes@sad.hp.com ************** Only 109 days left until Opening Day! (we hope) ***************