hi All,
i have one doubt please clear it. thanks in advance.
For ex i have one table with 2 columns as no, name in the backend
sqlbase.
Here i am showing some ex records.

No Name
----------------
1 a
1 b
1 c
2 asd
2 aas

Here my doubt is the No = 1 had 3 rows. i want to display as

No Name Desig Add
--------------------------------
1 a b c
2 asd aas

like this i want to display by using select statement is it possible?