Combine two select Queries

Question

I need a Query example to combine two Select Queries which uses same table and column name and display the result in a Single table Below is my Scenario select Column1count(Column2) as County from table1 where product='undefined' group by status select Column1count(Column2) as County from table1 where product='undefined' group by status Thanks in Advance!

Manas Mohapatra · Answer

You can use UNION ALL to get combined results. Try with below query: SELECT Column1 count (Column2) as County FROM table1 WHERE product= 'undefined' GROUP BY status UNION ALL SELECT Column1 count (Column2) as County FROM table1 WHERE product= 'undefined' GROUP BY status Note: Use UNION only to aviod duplicate records.