InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 14:05:40 GMT20http://www.sqlservercentral.com/Forums/Topic821823-146-1.aspxslightly different than the correlated subquery is the option of using a CTE. Use the cte to join back to the original table to get the results you are seeking.Thu, 19 Nov 2009 16:52:09 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic821823-146-1.aspxtable structure is:Name, numbersOnly this.Thu, 19 Nov 2009 11:11:31 GMTriver1http://www.sqlservercentral.com/Forums/Topic821823-146-1.aspxThis somewhat looks like homework, so I'll give you some hints here.I'd build an aggregate query that uses COUNT() to determine how many times each name appears. That it a very simple aggregate. Then make that a subquery and join it back to the original table on names, and join in the count from that subquery to get that value.Thu, 19 Nov 2009 11:10:47 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic821823-146-1.aspxInline correlated subquery is one way.Without knowing your table structure, I can't really provide sample code for how to do it.Thu, 19 Nov 2009 11:09:47 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic821823-146-1.aspxHi, I have a table named test. The table have this records:Name: Numbers:pedro 10 pedro 11 paulo 5 ana 7 ana 8ana 9 What i want is to make a select that will display a count for each equal name:Pedro 10 2pedro 11 2paulo 5 1Ana 7 3ana 8 3ana 9 3It will count the number of times that a name is equal.how can i make the select?Thank you.Thu, 19 Nov 2009 11:07:46 GMTriver1