[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 217
  • Last Modified:

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
0
kermodie
Asked:
kermodie
  • 4
1 Solution
 
sdstuberCommented:
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now