Author name: admin

SQL Aliases are the temporary names given to table or column for the purpose of a particular SQL query. It […]

The SQL HAVING Clause The HAVING clause was added to SQL because the WHERE keyword could not be used with

The SQL GROUP BY clause is used in collaboration with the SELECT statement to arrange identical data into groups. This

SQL UNION The UNION operator is used to combine the result-set of two or more SELECT statements. Each SELECT statement

The FULL OUTER JOIN keyword return all records when there is a match in either left (table1) or right (table2)

The INNER JOIN  selects records that have matching values in both tables. INNER JOIN Syntax: SELECT column_name(s) FROM table1 INNER

The SQL right join returns all the values from the rows of right table. It also includes the matched values

The SQL left join returns all the values from the left table and it also includes matching values from right

In the SQL outer JOIN all the content of the both tables are integrated together either they are matched or

A SQL JOIN clause is used to combine rows from two or more tables, based on a related column between