combine into a single SQL query both the first date and the total number of dates that are returned -
i want combine single sql query both first date , total number of dates returned where
clause.
i can 2 separately:
select dateadded table id = x order dateadded asc limit 1
and
select count(*) table id = x
but how merge these 2 queries?
how about,
select min(dateadded), count(*) table id = x
since don't specifiy engine using, avoids far standardized limit
keyword.
Comments
Post a Comment