You are here
Home > Posts tagged "select"


SQL: IS OPERATOR In this post we will learn IS operator it is use with NULL and NOT NULL operator to check whether a value is null or not. In database NULL is unknown or missing value, therefor we can not use the <, > ,= operators to check value is

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,