Category Archives: SQL

SQL – INNER JOIN

SQL – INNER JOIN Inner Join is synonymous to equi joins. It fetches rows from one or more tables based out of matching values of the […]

Read More

IN-BETWEEN

SQL – IN, BETWEEN

SQL – IN, BETWEEN IN – If you can recollect how the OR operator worked in SQL, the IN operator is similar to it. However, […]

Read More

LIKE

SQL – LIKE

SQL – LIKE In order to search for a particular pattern in a column, you can use the LIKE operator in the WHERE clause. When […]

Read More

SQL AND-OR-NOT

SQL AND/OR/NOT SQL provides 3 different logical operators(AND, OR, NOT) to use either separately or in combination in a WHERE clause. This is similar to […]

Read More

SQL DELETE

SQL DELETE The DELETE operation is used for deleting rows in a table. You can either delete one row at a time or multiple rows […]

Read More