Multiple select statements in Single query

by 
SELECT  (
    SELECT COUNT(*)
    FROM   user_table
) AS tot_user,
(
    SELECT COUNT(*)
    FROM   cat_table
) AS tot_cat,
(
    SELECT COUNT(*)
    FROM   course_table
) AS tot_course

More Related Contents:

  1. SQL select only rows with max value on a column [duplicate]
  2. What is the error “Every derived table must have its own alias” in MySQL?
  3. Generating Depth based tree from Hierarchical Data in MySQL (no CTEs)
  4. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  5. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  6. How to grant remote access permissions to mysql server for user?
  7. mySQL convert varchar to date
  8. Generating a series of dates [duplicate]
  9. How to escape single quotes in MySQL
  10. MySQL comparison with null value
  11. Why is the estimated rows count very different in phpmyadmin results?
  12. Slow query when using ORDER BY
  13. How to import XML file into MySQL database table using XML_LOAD(); function
  14. Unique constraint that allows empty values in MySQL
  15. Matching all values in IN clause
  16. INTERSECT in MySQL
  17. Having both a Created and Last Updated timestamp columns in MySQL 4.0
  18. MySQL select with CONCAT condition
  19. mysql field name from variable
  20. What does SQL clause “GROUP BY 1” mean?
  21. Bogus foreign key constraint fail
  22. MySQL SELECT LIKE or REGEXP to match multiple words in one record
  23. Syntax error when using except in a query
  24. Easiest way to copy a table from one database to another?
  25. sql like operator on integer
  26. How to make a primary key start from 1000?
  27. The best way to remove value from SET field?
  28. connecting to a docker-compose mysql container denies access but docker running same image does not
  29. MySQL’s lower_case_table_names won’t change
  30. Optimistic locking in MySQL

Leave a Comment