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: 96

Filed under:

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

Related posts about mysql