Re: Select count(*) problem

Posted in 2000

Carlos Benjamin — Mon, 22 May 2000 09:23:36 -0700 — source: Informix-list mailing list archive (1991-1998)

Obnoxio The Clown <obnoxio@hotmail.com> wrote: >select column_b, count(*) >from table_x >where column_a=12345 >group by column_b >having count(*) > 200 >into temp fred;> >select count(*) >from fred;> Except you'll have to give a name to count(*) in the first select statement. The fred.column_b is implied in the select into. select column_b, count(*) cnt carlos Currently on hiatus from unemployment. ---------------------- Do you do Linux? :) Get your FREE @linuxstart.com email address at: http://www.linuxstart.com