Member Avatar for zrony

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

  • 2 Contributors
  • 1 Reply
  • 113 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by smantscheff
Member Avatar for smantscheff

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.