SQL Server PIVOT Example: Turn Rows into Columns

select pvt.abc,pvt.def,pvt.ghi
from
(
SELECT      ConnectionName, Connection.ConnectionString
FROM         dbo.Global_Applications_ConnectionString AS Connection
 ) AS SourceTable
pivot (
 min(ConnectionString)
 for ConnectionName in (abc,def,ghi)
)  as pvt