||name||village||
-----------------
||A||v1||
||B||x1||
||A||v2||


i want to make sql query which returns me
A v1
A v2
B x1