Need help in sql query [message #372917] |
Sat, 17 March 2001 12:40 |
Bijoy Jacob
Messages: 1 Registered: March 2001
|
Junior Member |
|
|
My table look like this
Name State Code Gender
---------------------------
john florida t100 male
john florida t100 female
john florida t100 undefined
bob georgia m100 both
tom texas m100 male
tom texas t100 female
TOTAL RECORD IS 6
Here i want to combine the identical records in one line , for example like this :
Name State Code Gender
-------------------------------
john florida t100 male,female,undefined
bob georgia m100 both
tom texas m100,t100 female,male
TOTAL RECORD IS 3.
Since the fisrt three records look alike except gender I want to combine all three records in one line .So
Basically what i am trying to do is make as small as possible.please reply asap
|
|
|