Find the number of unique values in a table

Question

I have a table with four columns:

PartNumber, ValvePartNumber, ActuatorPartNumber, Price

I want to find the number of distinct prices for each combination of ValvePartNumber and ActuatorPartNumber.

This is using SQL Server 2005

+1

Ross goddard 05 dec. '08 at 20:28

1 answer

Jonathan Lonowski · Accepted Answer · 2008-12-05T20:36:13+0000

You can combine COUNT(DISINTCT)

and GROUP BY

to accomplish this.

SELECT ValuePartNumber, ActuatorPartNumber, COUNT(DISTINCT Price) AS Prices
FROM [Table]
GROUP BY ValuePartNumber, ActuatorPartNumber

Find the number of unique values ​​in a table