Can we get records in a single row

Question

Hi,

Can we get records of single column into a single row? If it is possible, then what will be sql statement for this.

Thanks.