Article:
  SQL Subqueries
Subject:   number of rows returned by query
Date:   2004-10-12 04:13:55
From:   dev-1
Response to: number of rows returned by query

Try the following Query>>


select count (*)
from chains where idchain in(
select idchain from chains
group by 1
having count (idchain) > 1
)

Main Topics Newest First

Showing messages 1 through 1 of 1.

  • number of rows returned by query
    2008-11-17 03:53:11  amit78g [View]

    No. I guess it should be this:

    select count (*)
    from (
    select idchain from chains
    group by 1
    having count (idchain) > 1
    )