Inconsistent working of SQL

[Subbarao]

I have found that the following query works very well in OpenOffice. I am not
sure what is wrong with MS Office. It just doesn't work. Can anyone help me
please ?

select count(duplicate snum) from SP

Here SP is a table with three columns namely snum(stands for supplier
number), pnum(stands for product number) and quantity. I want to fetch count
of distinct suppliers.

 

[Jerry Whittle]

SELECT snum, count(snum)
FRON SP
GROUP BY snum ;

I've never ran into "duplicate" used like that before. Interesting.