1. We have moved to a new forum! There may be a few things not working properly so please let us know if you find a bug. Remember to use the bbCode [ sql ] tag for SQL statements.
New XenForo forum! Google Ads

to convert rows to column using SQL?

Discussion in 'SQL - Questions and Answers' started by anuj, Oct 15, 2006.

  1. anuj Guest

    Dialect: MySQL
    plese tell me how to convert the rows in to columns in postrgres........
    anuj, Oct 15, 2006
    #1

  2. Juan carlos Guest

    Dialect: T-SQL
    SQL:

    
SELECT	COLUMNNAME 
    
FROM DBC.COLUMNS
    
ORDER BY COLUMNID;


    * RESULT IN TERADATA SQL
    ColumnName
    SECT
    GARA
    BIEN

    * I want obtained
    SECT;GARA;BIEN;
    Juan carlos, Dec 26, 2006
    #2

Share This Page