Advanced(?) query question

#11

In article <ZWuab.6834$nU6.1269431 (AT) twister (DOT) nyc.rr.com>, jag (AT) acm (DOT) org
says...

Quote:

SELECT CNT.country_id
FROM Countries AS CNT
INNER JOIN
Cities AS CIT
ON CNT.country_id = CIT.country_id
WHERE CNT.password IS NULL
GROUP BY CNT.country_id
HAVING COUNT(*) <= 10

Thanks, it worked out great. Maybe about time to brush up on the GROUP BY
/ HAVING clauses. =)

\Anders

#12

"Anders Steinlein" <dinhelt (AT) online (DOT) noSPAM> wrote

Quote:

In article <W_wab.235$9e2.21597243 (AT) mantis (DOT) golden.net>, bbadour (AT) golden (DOT) net
says...

SELECT CNT.country_id
FROM Countries AS CNT
INNER JOIN
Cities AS CIT
ON CNT.country_id = CIT.country_id
WHERE CNT.password IS NULL
GROUP BY CNT.country_id
HAVING COUNT(*) <= 10

John,

Do you complete your kids' homework for them too?

Oh, ok, so you just assume this was a homework assignment? Why? Cause no,
it is not a homework assignment, but part of a project for my own
company. Sure, I may not be an expert in SQL, but that shouldn't
automatically translate to it being a homework assignment, should it?

With all due respect, Anders, it matters little to me whether it is homework
for a school assignment or homework necessary for you to understand how to
perform your job.

I know those who provided cookbook recipes for you to follow did you no
favours.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Advanced(?) query question

comp.databases.theory comp.databases.theory

Re: Advanced(?) query question - 09-19-2003 , 01:20 PM

Re: Advanced(?) query question - 09-19-2003 , 01:39 PM