Answers for "change column name in sql select statement"

change name of colum in sql table

ALTER TABLE "table_name" RENAME COLUMN "column 1" TO "column 2";

Posted by: Guest on September-11-2020

sql change column name based on value

SELECT CASE lower(col1)
	WHEN 'agree' THEN 'Ok'
    ELSE
        CASE 
            WHEN col2 = 1 THEN 'Ko'
            ELSE 'Maybe'
        END
END AS my_result
FROM table_name;

Posted by: Guest on July-04-2021

Code answers related to "change column name in sql select statement"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "change column name in sql select statement"

Code answers related to "change column name in sql select statement"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "change column name in sql select statement"

Code answers related to "change column name in sql select statement"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us