SELECT DISTINCT MOBILE AND NAME1,NAME2.................
I HAVE TABLE like this
SNO MOBILE NAME
1 9849313820 VAMSHI
2 9849313820 RAJU
3 9849313820 PRANAY
4 9000066621 SUPRAJ
5 9000066621 ARAVIND
6 9866029167 ANR
7 9866029167 SUVARNA
SELECT DISTINCT MOBILE NUMBER AND SELECT NAMES1,NAME2,NAME3......
i wnt select like this....
SNO MOBILE NAME 1 NAME 2 NAME 3
1 9849313820 VAMSHI RAJU PRANAY
4 9000066621 SUPRAJ ARAVIND
6 9866029167 ANR SUVARNA