Search Posts

Author: Debs

Get count of multiple table records with group by function

how to – Get count of multiple table records with group by function I have 2 tables : priority_list and priority_list_delete I want to get the following data in a single row: 1) Sum of these 2 table records 2) Count of individual table records 3) Count of priority_list_delete table records category wise This is what I have done so far: SELECT (SELECT COUNT(*) FROM priority_list)+(SELECT COUNT(*) from priority_list_delete) as tot_count, (SELECT COUNT(*) FROM priority_list) […]