Inconsistent working of SQL

  • Thread starter Thread starter Subbarao
  • Start date Start date
S

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.
 
SELECT snum, count(snum)
FRON SP
GROUP BY snum ;

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