how can distinct repeated data of multiple columns from a table

hello

how can distinct data of select mutiple column having repeated data.
example

id name city locality
1 deep b 11
2 rohit b 11
3 deep c 12
4 mohit c 11
5 rohit a 13
6 moni a 13

from above table, what query i used to fetch non repeated data
name city locality
deep b 11
rohit a 12
mohit c 13

is it possible to fetch above solution by one query
if no,
so plz tell me how can solve my problem

plz help me

thanks everyone

Newbie Poster

8 posts since Feb 2012

Reputation Points: 10

Solved Threads: 0

It is not clear what you want. In your example, "moni" got lost. How would the result row containing moni look like?

Nearly a Posting Virtuoso

1,233 posts since Oct 2010

Reputation Points: 300

Solved Threads: 254

This article has been dead for over three months

You