MySQL Forums
Forum List  »  Newbie

Need help Building mysql query to count specific data under same table/row
Posted by: Praveen yadhav
Date: September 26, 2016 05:12AM

Table name "events"

user_id event_type Created
123 Flash C log 25-Sep-16
127 Client C log 25-Sep-16
123 Flash C log 25-Sep-16
126 Flash C log 25-Sep-16
185 Monitor log 25-Sep-16
146 Delete log 25-Sep-16
173 Flash C log 26-Sep-16
183 Client C log 26-Sep-16
193 Flash C log 26-Sep-16
204 Monitor log 27-Sep-16
214 Delete log 27-Sep-16
225 Flash C log 27-Sep-16

**Expect result**

Date Flash C log Client C log
25-Sep-16 2 1
26-Sep-16 2 1
27-Sep-16 1 0

I have tried the query which is posted on the comment, this gives me both the results same and is not accurate.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.