Mysql Count
Posted
by Buda
on Stack Overflow
See other posts from Stack Overflow
or by Buda
Published on 2009-03-31T13:56:33Z
Indexed on
2010/05/04
12:58 UTC
Read the original article
Hit count: 98
mysql
I have the following query:
select MIN(q.a), * FROM
(
sub-query1
) as q
UNION
sub-query2
How can I return the number of elements in query1 as a row of master-query?
If i use count (*) i´ve only the count
CountElementSub-Query1
i need some like that
rowA, rowB, rowC, CountElementSub-Query1
rowA, rowB, rowC, CountElementSub-Query1
rowA, rowB, rowC, CountElementSub-Query1
rowA, rowB, rowC, CountElementSub-Query1
© Stack Overflow or respective owner