You are here
Home > Posts tagged "Group 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


Welcome to SQL quiz. we have list of questions and there is no time limit for giving the answer. this quiz improve your SQL and database knowledge.We have divided SQL quiz into three parts.     Keep Visiting for more upcoming top technical articles. Detail course about DBA visit TechNet Consultancy You can