I want to get two differents results from the same table, I mean:
SELECT count(*) as Lec FROM my_table WHERE fecha_lec < '2012-04-24';
SELECT count(*) as Rec FROM my_table WHERE fecha_rec < '2012-04-24';
I would like to join both results and launch only one query, is it possible?
Thanks so much.