How to count unique on more than one column

Posted in 1996

Manickam R Muthukumar — Thu, 07 Nov 1996 17:54:10 -0500 — source: Informix-list mailing list archive (1991-1998)

Hi cid folks, I wanted to count unique on two columns (select count(unique col1,col2 from tab1) is there any solution without using temp table. Above syntax gives me a syntax error. Any help is greatly appreicated. Cheers -- ~~~~ SMILE !! increases the face value ~~~~~~~~~~~~~ M.R.Muthukumar Database Consultant Email:m_muthukumar@litle.net muthukumar@geocities.com http://www.geocities.com/SiliconValley/9956/ !! Strong believer in making things work !! (Opinion expressed here are mine only) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~