i have to count how many supplier there is, so im counting the
supplierID, but sometimes the suplierID ocur several times.
How can i count it only one time ?

exemple:
2
2
1
3
6
6

there is 4 suppliers (not6 like i get actualy)

SELECT COUNT(ITEMS.SUPPLIERID) AS NUMBER_OF_COMP
FROM ITEMS
thanks

Oracle LazyDBA home page