Trunc(date) group by query
867928Jan 30 2012 — edited Jan 30 2012Hi.
I have the following queries:
1) select trunc(fechaalta), count(*) solicitudes from solicitud group by trunc(fechaalta)
trunc(fechaalta) solicitudes
30/01/12 14
29/01/12 28
28/01/12 205
2) select trunc(fechaalta), count(*) ots from ot group by trunc(fechaalta);
trunc(fechaalta) ots
30/01/12 33
29/01/12 39
28/01/12 193
I need a table merging both queries. It would be like this:
trunc(fechaalta) solicitudes ots
30/01/12 14 33
29/01/12 28 39
28/01/12 205 193
How can I do it?.
Thanks.