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

Popular posts from this blog

Android layout hidden on keyboard show -

google app engine - 403 Forbidden POST - Flask WTForms -

c - Why would PK11_GenerateRandom() return an error -8023? -