Jump to content

Search the Community

Showing results for tags 'mysql query'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • W3Schools
    • General
    • Suggestions
    • Critiques
  • HTML Forums
    • HTML/XHTML
    • CSS
  • Browser Scripting
    • JavaScript
    • VBScript
  • Server Scripting
    • Web Servers
    • Version Control
    • SQL
    • ASP
    • PHP
    • .NET
    • ColdFusion
    • Java/JSP/J2EE
    • CGI
  • XML Forums
    • XML
    • XSLT/XSL-FO
    • Schema
    • Web Services
  • Multimedia
    • Multimedia
    • FLASH

Calendars

  • Community Calendar

Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests


Languages

Found 1 result

  1. Table name "events" user_id event_type Created 123 Flash Client log 25-Sep-16 127 Client Cyber log 25-Sep-16 123 Flash Client log 25-Sep-16 126 Flash Client log 25-Sep-16 185 Monitor log 25-Sep-16 146 Delete log 25-Sep-16 173 Flash Client log 26-Sep-16 183 Client Cyber log 26-Sep-16 193 Flash Client log 26-Sep-16 204 Monitor log 27-Sep-16 214 Delete log 27-Sep-16 225 Flash Client log 27-Sep-16 Expected result Date Flash Clien 25-Sep-16 2 1 26-Sep-16 2 1 27-Sep-16 1 0 I was using below query but this wont show the required result. SELECT COUNT (DISTINCT e.user_id) AS Flash, COUNT (DISTINCT et.user_id) AS Client, TO_CHAR (e.created) AS Date_created FROM events e INNER JOIN events et ON e.user_id = et.user_id WHERE e.created BETWEEN '25-SEP-15' AND '27-SEP-15' AND e.event_type = 'Flash Client log' AND et.event_type = 'Client Cyber log' GROUP BY TO_CHAR (e.created); ** I have uploaded image of the table as the data provided above is not aligned and I did not get insert table on this forum post
×