You are here
Home > Posts tagged "order by"

SQL: Logical Query Processing Phases

Logical Query Processing Phases In this post we will discuss logical query processing phases in SQL server. Logical query processing means in which order the sql query clause is evaluated. The below table represent the order of clause evaluation in SQL: Evaluation No SQL clause 1 From (join, pivot, unpivot, apply) 2 Where (predicate) 3 Group by (grouping sets,

Select Statement

SELECT STATEMENT In this post we will discuss about select statement in SQL server 2016. The select statement is used to retrieve records from the one or more tables. To retrieve all column of the table use an asterisk (*).       Syntax:       Select * from <table_name>; In this statement we can assign