SQL – IN Operator Table of content The SQL IN Operator The SQL IN Operator is used to specify multiple values or sub query in the WHERE clause. It returns all rows in which the specified column matches one of the values in the list. The list of values or sub query must be specified […]

SQL – Like Operator Table of content The SQL LIKE Operator The SQL LIKE operator is used to retrieve the data in a column of a table, based on a specified pattern. It is used along with the WHERE clause of the UPDATE, DELETE and SELECT statements, to filter the rows based on the given […]

SQL – BOOLEAN Table of content A Boolean is a universal data type which stores true or false values. It is used when we define a variable in a column of the table. For instance, a customer wants a list of all the red cars. So, we can find this using the BOOLEAN operator as […]