How to Merge the Headers of multiple columns in HTSQL

Question

I am making a Table in HTSQL, which results like:

Name  Total_Calls  Successful_Calls  Failed_Calls
John       9              5                4

Where as I want to merge the headers like:

           C  A  L  L  S
Name  Total  Successful  Failed
John    9        5          4

score 1 · Accepted Answer · answered May 16 '13 at 11:07

You could use :as to rename a column (total_calls to total) and then use brackets to mark your nested record. Here is an example:

1 Answers1