select * from
(
SELECT ID_number, count( CU_number ) AS CC
FROM MyTable
GROUP BY ID_number
) T
WHERE CC =
(
select max(cc) from
(
SELECT ID_number, count( CU_number ) AS CC
FROM MyTable
GROUP BY ID_number
) T2
)
On Wed, Oct 15, 2008 at 5:08 PM, dave aptiva <[EMAIL PROTECTED]>wrote:
> Hello a
SELECT ID_number, count( CU_number )
FROM MyTable
GROUP BY ID_number
order by 2 desc
limit 10
will give you the top 10. Change 10 to whatever you want or take off the
limit clause to get all records.
On Fri, Oct 17, 2008 at 4:25 AM, dave aptiva <[EMAIL PROTECTED]>wrote:
> Hello all,
>
> I'm new
2008/10/17 dave aptiva <[EMAIL PROTECTED]>:
>
> I tried SELECT ID_number, max( count( CU_number ) ) but this causes an error
> "# - Invalid use of group function "
# sqlite3
SQLite version 3.5.9
Enter ".help" for instructions
sqlite> create table moo (id_number, cu_number);
sqlite> insert int
