'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.

sql


Solution 1:[1]

I think an SQL statement like this should work!

SELECT Municipality FROM Province WHERE District = 'District Name'

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Jack