Create database objects such as tables, views, indexes, sequences, synonyms, stored procedures, user-defined functions, and triggers. First, let’s create some dummy data. It returns 1 for aggregated or 0 for not aggregated in the result set. By: Simon Liew | Updated: 2016-11-23 | Comments (4) | Related: More > Availability Groups Problem. To get the total salary given out to the employees,