multiple query same table but in different columns mysql

by

This is a pretty common pattern:

SELECT DAY_IN, COUNT(*) AS arr,
        SUM(IF(PAT_STATUS  like '%ong%', 1, 0)) AS ONG1,
        SUM(IF(PAT_STATUS  like '%rtde%', 1, 0)) AS RTED,
        SUM(IF(PAT_STATUS  like '%pol%', 1, 0)) AS POL1,
        SUM(IF(PAT_STATUS  like '%para%', 1, 0)) AS para
FROM t_hospital 
WHERE DAY_IN between @start_check and @finish_check 
    and RES_DATE between @start_res and @finish_res  
    and ID_daily_hos =@daily_hos
GROUP BY DAY_IN

More Related Contents:

  1. Which DB technology is sued to solve the following search issue? [closed]
  2. MySQL pivot row into dynamic number of columns
  3. How to join two tables mysql?
  4. mysql Foreign key constraint is incorrectly formed error
  5. Unknown Column In Where Clause
  6. Multiple Updates in MySQL
  7. SQL split comma separated row [duplicate]
  8. Storing JSON in database vs. having a new column for each key
  9. MySQL – Subtracting value from previous row, group by
  10. How do I restore a dump file from mysqldump?
  11. MySQL – Conditional Foreign Key Constraints
  12. How to count items in comma separated list MySQL
  13. Groupwise maximum
  14. Entity-Attribute-Value Table Design
  15. Filter by COUNT(*)?
  16. Error Code: 1406. Data too long for column – MySQL
  17. MySQL order by “best match”
  18. How to select rows that have current day’s timestamp?
  19. MySQL concatenation operator
  20. SQL Group By with an Order By
  21. Does mysql have the equivalent of Oracle’s “analytic functions”?
  22. MySql – Way to update portion of a string?
  23. Using reserved words in column names
  24. MySQL INNER JOIN select only one row from second table
  25. Storing IPv6 Addresses in MySQL
  26. Insert/ Update random date in MySQL
  27. Replace null with 0 in MySQL
  28. Get total hours worked in a day mysql
  29. Convert SQL Server query to MySQL [duplicate]
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment