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>>
|
||
Showing messages 1 through 1 of 1.
-
number of rows returned by query
2008-11-17 03:53:11 amit78g [View]
select count (*)
from (
select idchain from chains
group by 1
having count (idchain) > 1
)