# \#key

**URL:** https://clarionhub.com/tag/key/124.md

[Latest](https://clarionhub.com/latest.md) · [Categories](https://clarionhub.com/categories.md) · [Tags](https://clarionhub.com/tags.md)

---

## [Adding group columns to a key in the dictionary (Clarion 11.13401)](https://clarionhub.com/t/adding-group-columns-to-a-key-in-the-dictionary-clarion-11-13401/3493)

<div class="topic-metadata">

**Author:** [@StuAndrews](https://clarionhub.com/u/StuAndrews)\
**Replies:** 7\
**Last updated:** [August 26, 2020, 4:29am UTC](https://clarionhub.com/t/adding-group-columns-to-a-key-in-the-dictionary-clarion-11-13401/3493 "2020-08-26T04:29:07Z")

</div>

Hi Folks, I’m doing a lot of work in a MSSQL database and have been using the GROUP OVER technique (standard) for dealing with the sql DATETIME column type. One thing I’ve noticed for a while now is that I do not seem …