SQL OPERATORS AND FUNCTIONS | LATEST UPDATE { GUARANTEED A+}

SQL OPERATORS AND FUNCTIONS |

LATEST UPDATE { GUARANTEED A+}




IN - ✔✔Used in WHERE clause to match values


BETWEEN - ✔✔Determines if value is within a range


LIKE - ✔✔Matches text against a pattern with % and _


BINARY - ✔✔Makes LIKE case-sensitive with BINARY


DISTINCT - ✔✔Returns unique values in SELECT


ORDER BY - ✔✔Sorts selected rows in ascending order


DESC - ✔✔Orders rows in descending order


function / argument - ✔✔Function operates on argument(s) and returns a value


aggregate function - ✔✔Processes rows and returns summary value


COUNT() - ✔✔Counts rows in a set

, MIN() - ✔✔Finds minimum value in a set


MAX() - ✔✔Finds maximum value in a set


SUM() - ✔✔Adds all values in a set


AVG() - ✔✔Calculates mean of values in a set


GROUP BY - ✔✔Groups rows based on column(s)


HAVING - ✔✔Filters group results


join / left table / right table - ✔✔Combines data from two tables


AS - ✔✔Replaces column name with an alias


join clause - ✔✔Determines how a join query handles unmatched rows


INNER JOIN - ✔✔Selects matching rows from both tables


FULL JOIN - ✔✔Selects all rows from both tables


ON - ✔✔Specifies join columns


LEFT JOIN - ✔✔Selects all rows from left table


RIGHT JOIN - ✔✔Selects all rows from right table