facing problem in query

[dashingashish]

Is there any alternative for
select count(distinct column_name) from table1

[Stewart Ross]

Is there any alternative for
select count(distinct column_name) from table1

I am just guessing here as you have provided very little to go on. I suspect you need to count the number of rows for each group of items in column_name. If so, the SQL below may help:
[code=sql]SELECT [table1].[column_name], Count([table1].[column_name]) AS [Rows Counted]
FROM [table1]
GROUP BY [table1].[column_name];[/code]
-Stewart