Query HELP....

• Leo-696352

  SSCrazy

  Points: 2708

  More actions

  October 16, 2008 at 6:28 am

  #154815

  Hi,

  I have a table called TEST, that contains 3 rows which are -

  RowNo EmpNo Phonenumber

  1 1 0199299123

  2 1 0199299123

  3 1 0199299124

  4 1 0199299125

  5 1 0199299123

  6 1 0199299125

  I want the result in -

  EmpNo Phonenumber TotalCalled

  1 0199299123 3

  1 0199299124 1

  1 0199299125 2

  Anybody know how to write a query to come up like above.

  Thanks.

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  October 16, 2008 at 6:33 am

  #885753

  Select

  EmpNo,

  PhoneNumber,

  Count(RowNo) as total_calls

  From

  dbo.Test

  Group By

  EmpNo,

  PhoneNumber

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• Leo-696352

  SSCrazy

  Points: 2708

  More actions

  October 16, 2008 at 6:37 am

  #885755

  Hi Jack,

  Thanks. What a good one.

  Leo