Beginning MySQL Tutorial
One of the fastest SQL (Structured Query Language) database servers currently on the market is the MySQL server, developed by T.c.X. DataKonsultAB. MySQL, available for download at http://www.mysql.com, offers the data base programmer with an array of options and capabilities rarely seen in other database servers. What's more, MySQL is free of charge for those wishing to use it for private and commercial use.
| Name: |
Dan Monahan |
| Subject: |
Re: DISTINCT Clause Problem |
| Date: |
09-08-1999 10:05PM |
I am having the *exact* same problem. I don't know what I'm doing wrong. I am performing the same query:
mysql> SELECT DISTINCT
-> COUNT(SELECT userName FROM test3responses)
-> FROM test3responses;
ERROR 1064: You have an error in your SQL syntax near 'SELECT userName FROM test3responses)
FROM test3responses' at line 2
mysql> SELECT COUNT
-> (SELECT DISTINCT userName FROM test3responses)
-> FROM test3responses;
ERROR 1064: You have an error in your SQL syntax near '(SELECT DISTINCT userName FROM test3responses)
FROM test3responses' at line 2
mysql>
As you can see, I tried different forms of the same query, but I'm clueless as well. Please let me know if you find a solution.
Thanks!
|
Other posts in this thread:
Reply to this post:
|
 |
Visit the MySQL Forum!
New On DevShed:
Hot Forum Topics:
|
