I think you need to name the column Select count(*) as cnt, column1 from table
You might also have to explicitly select each column when you use aggregates in your query, but I'm not sure. Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -----Original Message----- From: Steve Abaffy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 10:42 AM To: ActiveServerPages Subject: OT: Quick SQL Query Question Hello, How do I write a query that will return all the rows in a table with the addition of the count of those rows? Something like Select Count(*),* From table Thanks in Advandce --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
