Hi,
I have a problem about writing a proper SELECT query
for the following goal: (I only have basic knowledge
of SQL)
Table name: peoplelist
column 1: id (not NULL, auto_incremental)
column 2: name
column 3: country
now, there are about 7,000 rows in this table. I want
to select out:
first
Try something like this:
SELECT ID, Name, Country
FROM peoplelist
GROUP BY Country
HAVING count(Country)10;
That might work. Also you can have subselects in 4.0.
sub selects are only in 4.1 I thought?
On Mar 3, 2004, at 5:08 PM, Jacque Scott wrote:
Also you can have subselects in 4.0.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You are correct. Sorry about that.
charles kline [EMAIL PROTECTED] 3/3/2004 2:46:51 PM
sub selects are only in 4.1 I thought?
On Mar 3, 2004, at 5:08 PM, Jacque Scott wrote:
Also you can have subselects in 4.0.