You are here
Home > Posts tagged "where"

SQL: IS OPERATOR

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,

Update Statement

UPDATE STATEMENT In this post we will discuss about update statement in SQL server 2016. UPDATE: SQL support the update statement to allow us to modify or change the existing data in a tables. The update statement in SQL either update all the rows from a table or a selected set of

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

Top