SQL Server row to column small case

PIVOT syntax.

SELECT < non-perspective columns;

[First pivot column] as < column name;

[Second pivot column] as < column name;

...

[Last Pivot column] as < column name;

From

(< SELECT query > for generating data)

Aliases for as < source queries >

PIVOT

(

< aggregate functions > (< Columns to aggregate >)

For

[< The column that contains the value to be the column header;]

In ([First pivot column], [Second pivot column],

... [last pivot column])

) as < pivot table Aliases >

< optional ORDER by clause >;

SELECT * FROM Student
Pivot (max (score) for project in ([Language],[Math],[Foreign Language]) as Pvt

SQL Server row to column small case