CODEWITHSUNDEEP
sql
Anjana Bhattrai
Anjana Bhattrai

Reputation: 1

python-sql query

I have a table named Province with column name id, District and Municipality. So, If I select any District values , then its respective municipality value should be displayed. How do I do it?

enter image description here

If I select District values named Kapilvastu, then its respective Municipality values named Kapilvastu should come as an output.

Upvotes: 0

Views: 55

Answers (1)

Jack
Jack

Reputation: 11

I think an SQL statement like this should work!

SELECT Municipality FROM Province WHERE District = 'District Name'

Upvotes: 1

Related Questions