General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Add /HAVING fecha=42/ clause.
>hello, i have this query:
>
>SELECT count(fechaingreso) as fecha
>FROM registroempresas
>group by fechaingreso
>
>what i trying to do is find how many people appears in my table in a date range and from that extract the maximum of the values.
>Right now it shows 42, 1, 3, 2, etc., but i need to choose only the 42 from there, how can i do this?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only