Re: Three valued logic (again)

Posted in 1997

Ian Goddard — Fri, 07 Mar 1997 00:23:27 -0800 — source: Informix-list mailing list archive (1991-1998)

Jonathan Leffler wrote: > > With 7.2x, the notation below counts the number of non-null values in the > specified column. It is an SQL-92 feature which has finally been added to > Informix databases. > > SELECT COUNT(Column) FROM Table [WHERE ...];> Jon, Is that the count of number of rows with non-null values of Column (as opposed to COUNT(DISTINCT Column) (if I remember the syntax correctly)? Ian