InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 19:34:05 GMT20http://www.sqlservercentral.com/Forums/Topic732893-338-1.aspxThis sounds a bit like a school work type question so without wanting to give too much of an answer I'd suggest you look at the GROUP BY clause - that should help you find the answer.Thu, 11 Jun 2009 04:59:12 GMTSQLZhttp://www.sqlservercentral.com/Forums/Topic732893-338-1.aspxI have 2 tables with customer id in one coulmn and orderid in another table.I need to find out the customers having maximum number of unique orders.finf customer 1 has 4 different orders i need to display the count as 4 against customer 1.Thu, 11 Jun 2009 04:36:53 GMTsreekirt-1108866