Try
SELECT lastip,username FROM users HAVING count(*) > 1 GROUP BY lastip;
(or possibly
SELECT lastip,username FROM users GROUP BY lastip HAVING count(*) > 1;
)
david
On Wednesday 24 October 2001 2:21 pm, David Wolf wrote:
> I'm trying to come up with a query to do the following... I'm no
gt; [EMAIL PROTECTED]
>
>
> -Original Message-
> From: David Hugh-Jones [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 23 October, 2001 13:10
> To: [EMAIL PROTECTED]
> Subject: selecting rows where all rows meet a criterion
>
>
>
> OK, I have a tricky SQL syntax pro
ere students.id=grades.id
> and min(grades.grade - students.average_grade) > 0
> group by students.id
>
>
> Tom Haapanen
> [EMAIL PROTECTED]
>
>
> -Original Message-
> From: David Hugh-Jones [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 23 October, 2001 13:1
OK, I have a tricky SQL syntax problem I would like to share.
For simplicity's sake, I'll use an analogy. I have two tables, of students
and grades, each with a "ID" column for use in joins, corresponding to a
student's ID.
The student table has an "average grade" column which shows that stud
, but just wanted to check.
sql sql sql. dumb email filter.
--
David Hugh-Jones
iDomainCart
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
