SQL Subquery?! A count on a count??

Trying to perform a SQL Subquery ...

this is the one that just wont work...

Select COUNT (SELECT COUNT(*)
FROM Table
WHERE GROUP BY ID)

... can anyone help me out with this one?

Comments

  • : Trying to perform a SQL Subquery ...
    :
    : this is the one that just wont work...
    :
    : Select COUNT (SELECT COUNT(*)
    : FROM Table
    : WHERE GROUP BY ID)
    :
    : ... can anyone help me out with this one?
    :

    try:

    select count(*) from
    (select count(*) as counts from Table group by ID) as A



Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories