I have following requirement from my user. I have a table which has column col1, col2, col3 and col4. Now using SQL I want the output to be displayed as Col1 Col2 col1 col3 col1 col4 Please suggest how can we achieve this? Thanks