You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: docs/t-sql/queries/select-over-clause-transact-sql.md
+3-3Lines changed: 3 additions & 3 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -130,7 +130,7 @@ from sys.objects
130
130
### PARTITION BY
131
131
Divides the query result set into partitions. The window function is applied to each partition separately and computation restarts for each partition.
132
132
133
-
```sqlsyntax
133
+
```syntaxsql
134
134
PARTITION BY *value_expression*
135
135
```
136
136
@@ -162,7 +162,7 @@ from sys.objects
162
162
163
163
### ORDER BY
164
164
165
-
```sqlsyntax
165
+
```syntaxsql
166
166
ORDER BY *order_by_expression* [COLLATE *collation_name*] [ASC|DESC]
167
167
```
168
168
@@ -251,7 +251,7 @@ order by object_id asc
251
251
#### BETWEEN AND
252
252
**Applies to**: [!INCLUDE[ssSQL11](../../includes/sssql11-md.md)] and later.
253
253
254
-
```sqlsyntax
254
+
```syntaxsql
255
255
BETWEEN <window frame bound > AND <window frame bound >
256
256
```
257
257
Used with either ROWS or RANGE to specify the lower (starting) and upper (ending) boundary points of the window. \<window frame bound> defines the boundary starting point and \<window frame bound> defines the boundary end point. The upper bound cannot be smaller than the lower bound.
0 commit comments