Skip to content

SQL capitalization column

Jump to bottom Edit New page
Tako Lee edited this page Feb 20, 2014 · 3 revisions

Column name has a dedicated case option.

SELECT DEPARTMENT_ID, 
       Min( SALARY )  
FROM   employees 
GROUP  BY DEPARTMENT_ID
Column mapping file

User can also specify a column mapping file that all columns should be capitalized exactly the same as the one in this file. Column name in this mapping file should be one column per line with desired case. If column name is not found in this mapping file, then case option for column name applied.

PP V3 format options

Add a custom sidebar

Clone this wiki locally