ignedup
> HAVING COUNT(b.*) <= 5;
>
> ----- Original Message -----
> From: "Aaron Burnett"
> To:
> Sent: Tuesday, June 08, 2010 6:04 PM
> Subject: [SQL] Some insight on the proper SQL would be appreciated
>
>
>>
>> Greetings,
>>
>&g
Mikhail,
Thank you very much. This seems to have worked perfectly.
On 6/8/10 1:58 PM, "Mikhail V. Puzanov" wrote:
> Hi,
>
> Something very straightforward looks like this, I guess:
>
> select * from users u
> where (
> select count(*) from users u1
> where u1.username = u.username
Hi,
Something very straightforward looks like this, I guess:
select * from users u
where (
select count(*) from users u1
where u1.username = u.username
and u1.signedup> u.signedup
)< 5
to get recent results. Or "u1.signedup< u.signedup"
for the first ones. But that doesn't work i
;= b.signedup
GROUP BY a.username,a.firstname,a.lastname,a.signedup
HAVING COUNT(b.*) <= 5;
- Original Message -
From: "Aaron Burnett"
To:
Sent: Tuesday, June 08, 2010 6:04 PM
Subject: [SQL] Some insight on the proper SQL would be appreciated
Greetings,
Any help on this wou
Greetings,
Any help on this would be appreciated.
I have a table which is a list of users who entered a contest. They can
enter as many times as they want, but only 5 will count. So some users have
one entry, some have as many as 15.
How could I distill this down further to give me a list that
