0 - 1 of 1 tags for sql looping reccursion

Have to create a view from base table below. The record count of base table is not constant.

 

Base table:-

-----------------------

Country | State

----------------------

India      KL

India      TN

India      KA

India      WB

India      UP