Skills SQL Server TSQL: Difference between revisions
No edit summary |
No edit summary |
||
| Line 31: | Line 31: | ||
== Joins == | == Joins == | ||
== Stored Procedures == | |||
<div class="mw-collapsible mw-collapsed" style="width:400px; overflow:auto;"> | |||
<div>''Used at:...''</div> | |||
<div class="mw-collapsible-content"> | |||
''Used at: '' | |||
''[[Role_MUFG_Securities|MUFG Securities]]'' | |||
''[[Role_Five_Guys|Five Guys]]'' | |||
</div> | |||
</div> | |||
Revision as of 19:57, 2 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