Try,
Select count(distinct(pmaid)) from dbc.resusagespma;
Dave
Ward Analytics Ltd: Information in motion ( www.ward-analytics.com )
Recent Threads
Attachments
Library
Quick Reference
Useful Links
Rules of Conduct
FAQs
Join the Forum
Archives
Sample Index
2004 Indexes