[snip] select count(*) from store group by orederId. For the above sql, I am not getting the count of unique order ids.. [/snip]
select orderID, count(*) from store group by orderID -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]