Skills SQL Server TSQL: Difference between revisions
| Line 51: | Line 51: | ||
''[[Role_Autodata|Autodata]]'' | ''[[Role_Autodata|Autodata]]'' | ||
</div> | </div> | ||
</div>Pivot function | </div> | ||
Pivot function | |||
Unpivot function | |||
Revision as of 08:20, 3 October 2024
Used at:...
Used at: MUFG Securities SSE_Energy_GDPR
Window functions
Group by/aggregation
WHERE clause / Having
CTE - Common Table Expressions
Used at:...
Used at: MUFG Securities
Use of SQL Server CTEs (Common Table Expressions).
Sorting
Sort by
Sub-queries
Views
Joins
Stored Procedures
Used at:...
Used at: MUFG Securities Five Guys Premier Foods Autodata
Pivot
Used at:...
Used at: Autodata
Pivot function
Unpivot function