CODEWITHSUNDEEP
sql
Piper Esguerra
Piper Esguerra

Reputation: 11

How can I get Counts on Multiple tables? in SQL

SELECT `p2`, COUNT(*) FROM dsf_2022_raw_new WHERE `p2` LIKE 'BA' 

p2   COUNT(*)
BA    608

I was able to get count from that table but I need to get "BA" from 4 more tables with similar structure.

Then what if I want to select BA, DL, TS, AL these are actually first two characters of the post code.

Upvotes: 0

Views: 50

Answers (1)

mowgle
mowgle

Reputation: 13

welcome to Stack Overflow. So, looks like you're asking two questions there.

  1. Regarding getting the count from four separate tables, I suggest running the same SQL query you've written on these four tables, saving each query output to a single view, and then running a group-by query to calculate the total count. Something like
SELECT count(*), p2 from <your_view> group by p2
  1. Selecting queries from multiple postcodes can be achieved using OR statements with your where clause. So, taking your original query,
SELECT p2, COUNT(*) FROM dsf_2022_raw_new 
WHERE p2 LIKE 'BA' 
OR WHERE p2 LIKE 'DL'...

Hope this helps. Happy coding

Upvotes: 1

Related Questions