Index_H

H

HAVING clause, 98, 328

to filter groups of rows, 97 “98

filtering rows using, 212

removing duplicate rows using, 214

subqueries in, 168 “169

vs. WHERE clause, 534 “535

with WHERE and GROUP BY, 98 “99

header and footer, adding to a report, 160 “161

hiding values, using asterisks for, 157

hierarchical queries, 194 “201

eliminating nodes and branches, 200

including other conditions, 201

result formatting, 197 “198

high performance SQL tuning, 529 “550

hints (optimizer), 548 “549

hour , datetime formatting parameters for, 107

hypothetical rank and distribution functions, 215, 234 “235