Programming Examples

Are you a Programmer or Application Developer or a DBA? Take a cup of coffee, sit back and spend few minutes here :)

Tag Archive for ‘Top with Ties’

Learn How to Use Order By Clause and Group By Clause

SQL Query with Aggregate, Group By, Order By and Having with Where conditions

1. Introduction to Grouping & Sorting In this article, we will explore group and sort the result of an SQL query. The Order By informs SQL engine to arrange the query output in ascending or descending order. To put it differently, the Order By will sort the output query result on a specific column or columns. We will also see how the TOP option behave with the Order By clause and then […]

Continue Reading →