Author Archives: user

SQL – NOT EQUAL Table of content The SQL NOT EQUAL Operator The SQL NOT EQUAL operator is used to compare two values and return true if they are not equal. It is represented by “<>” and “!=”. The difference between these two is that <> follows the ISO standard, but != doesn”t. So, it […]

SQL – NOT Operator Table of content Most of the times, there is a need to use two or more conditions to filter required records from a table; but sometimes satisfying one of the conditions would be enough. There are also scenarios when you need to retrieve records that do not satisfy the conditions specified. […]

SQL – CASE Table of content The SQL CASE Statement The SQL CASE statement is a conditional statement that helps us to make decisions based on a set of conditions. It evaluates the set of conditions and returns the respective values when a condition is satisfied. The CASE statement works like a simplified IF-THEN-ELSE statement […]