How to make query using sqlserver

Sign in to answer this question.

• MQ

  mohammad qasim14y agoPosted Mar 27, 2012, 7:24 AM

  I have solved
  
  solution
  
  
  
  

  select t.townname,count(distinct(t.towncode))as total  from town t

  group by t.townname

  
  
• 

  Jignesh Trivedi14y agoPosted Mar 27, 2012, 4:53 AM

  Hi,
  
  using Group by you can achive this.
  
  Select TownName, COUNT(1) as Total from table
  Group by towncodeNo ,TownName
  
  hope this help.