Hello all,the below tutorial will help you in displaying sql row data as a column wise with user specific column name.here, i've a table with #temp1 name that contains the following columns id, ...

In the figure above, column C1 is divided into groups, aggregate functions are applied, and a single value is assigned to each group. Here’s an example using a database named “appuals.” Database ...

In this sample statement, the condition (table1.keyfield=table2.keyfield) tells SQL to find records in both tables that contain matching values in the column named by keyfield.