In a table, there are 3 rows and 2 columns. I need to retrieve all the data, but instead of getting 3 rows of 2 columns each, I need to get one row of 6columns. Need to do that only in SQL !

for example,

EMPLOYEE table

NAME AGE
ABC 28
ZYA 38
XYZ 48


Now, how to get a single row from this table :

ABC 28 ZYA 38 XYZ 48

btw, i don't know the answer.

Any idea ?

Thanks,
AD