Here is my query- Select col1, col2, count(*) as total, count(col3 < col4) as violations from table1 Where condn group by col1, col2
The result of this query shows same values at both the columns for total and violations. The count(expr) does not work???? Thanks Meena -------
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php