Gates, Bill (Microsoft), 23
GENERAL (reserved word), 464
GET (reserved word), 462, 464
GETANSINULL() function, 201, 480
GETDATE() function, 180–181, 474
GETUTCDATE() function, 180–181, 474
GLOBAL (reserved word), 462, 464
GO (reserved word), 462, 464
GOTO (reserved word), 460, 462
GRANT command, 123, 346–347
GRANT (reserved word), 460, 462
GRANTEE view, 510, 517
GRANTOR view, 510, 517
graphical query designer, 88–93
grid pane in Query Designer tool, 53
GROUP BY clause, 213–217, 221, 452–453
GROUP (reserved word), 460, 462
grouped aggregates
COMPUTE BY clause, 228
COMPUTE clause, 225–228
GROUP BY clause, 213–217, 221
GROUPING() function, 223–225
HAVING clause, 218–219
subgrouping, 221
subtotals, 219–220
totals, 219–220
WITH CUBE operator, 222–223
WITH ROLLUP operator, 221–222
grouping data, 213–228
GROUPING() function, 223–225, 472
GROUPING (reserved word), 464
groups, adding, 436–442