sql count function for duplicate rows inserted into dreamweaver

I need to Identify the unique rows and put the number of times they are duplicated next to them.
I have tried the following from your existing response to another fellow:

SELECT cust_name, COUNT(*) AS count_name
FROM sometable
GROUP BY cust_name
HAVING COUNT (*) > 1

I tried putting this into a recordset with Dreamweaver and it chokes.
Any ideas?
Thanks
kermodieAsked:
Who is Participating?
 
sdstuberConnect With a Mentor Commented:
I suggest cross-posting this to a dreamweaver zone.

Your sql statement is correct syntax for all of the major databases.

So either your "choke" is something trivial like a misspelled column or table name

or it's a dreamweaver problem
0
 
sdstuberCommented:
glad I could help, could you post what it was that helped you?
0
 
kermodieAuthor Commented:
This is my first request for support.
It did not really help other than redirect my query to another area and I don't have the energy to pursue it here.  I was hoping somebody with dreamweaver experience might have picked out what isn't working.
0
 
sdstuberCommented:
oh, I was just suggesting adding it as an additonal zone, but ok.
0
 
sdstuberCommented:
good luck
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.