i have a table named locations of which i want to select and get values in such a way that it should select only distinct values from a column but select all other values .

table name: locations
column names 1: country values : America, India, India, India
column names 2: state/Province : Newyork, Punjab, Karnataka, kerala

when i select i should get India only once and all the three states listed under India . is ther any way..??? sombody please help