SQL LIKE Operator : SQL LIKE operator is used in a WHERE clause to search for a specified pattern in a column. There are two wildcards
Read moreAuthor: selva
SQL Wildcards
SQL Wildcards : SQL wildcards characters is used to substitute any other character(s) in a string. Wildcard characters are used with the SQL LIKE operator. The LIKE
Read moreSQL IN Operator
SQL IN Operator : SQL IN operator allows you to specify multiple values in a WHERE clause. The IN operator is a shorthand for multiple
Read moreSQL BETWEEN Operator
SQL BETWEEN Operator : SQL BETWEEN operator selects values within a given range. The values can be numbers, text, or dates. The BETWEEN operator is
Read moreSQL Aliases
SQL Aliases : SQL aliases are used to give a table, or a column in a table, a temporary name. Aliases are often used to
Read moreSQL Self JOIN
SQL Self JOIN : SQL Self JOIN is a regular join, but the table is joined with itself. Self JOIN Syntax SELECT column_name(s) FROM table1 T1, table1 T2
Read moreSQL UNION Operator
SQL UNION Operator : SQL UNION Operator is used to combine the result-set of two or more SELECT statements. Each SELECT statement within UNION must have
Read moreSQL GROUP BY Statement
SQL GROUP BY Statement : SQL GROUP BY Statement is often used with aggregate functions (COUNT, MAX, MIN, SUM, AVG) to group the result-set by one
Read moreSQL HAVING Clause
SQL HAVING Clause : SQL HAVING clause was added to SQL because the WHERE keyword could not be used with aggregate functions. HAVING Syntax SELECT column_name(s) FROM table_name
Read moreSQL EXISTS Operator
SQL EXISTS Operator : SQL EXISTS Operator is used to test for the existence of any record in a subquery. The EXISTS operator returns true if
Read more