what is sql query for for ID, count every case and show just date for time 1. sample: Output for ID=101 :
Please guide me about this.
(comments are locked)
|
I found the answer.
(comments are locked)
|
I would change your query to
The having clause happens after everything has been aggregated in the query, there WHERE clause happens before and will filter your data, although this is small query, you'll see bigger performance gains in the larger queries.
(comments are locked)
|