select only same names

Oct 30 2013 4:38 AM

i have table like this .............................

sno name mobile area
1 swapna 9849313821 hyd
2 abilash 987543211 hyd
3 swapna priya 98765313892 vizag
4 shashikiran 9765423111 hyd
5 shashi 9876543211 hyd
6 raju 9876557899 jyd

i want to select only same names ......

sno name mobile area
1 swapna 9849313821 hyd
3 swapna priya 98765313892 vizag
4 shashikiran 9765423111 hyd
5 shashi 9876543211 hyd

Answers (4)

compare two tables select not matching coloum in table b

Query to display day in sp