JOINS AND WINDOW FUNCTIONS IN SQL.

SQL stands for structured Query Language and is the language used to communicate with a database. What is a database An organized collection of data stored electronically. Data is stored in tables inside databases. SQL is used to retrieve data,update and analyse data. JOINS IN SQL Joins are used in SQL to combine rows from two or more tables based on a common relationship(primary key) TYPES OF JOINS INNER JOIN It returns rows that are same from both tables. EXAMPLE LEFT JOIN A Left join returns all rows from the left table and the matching rows from the right(second) table. If there are no matching values,NULL values are returned from the right table. EXAMPLE RIGHT JOIN A right join returns all rows from the right table and the matching rows from the left table. If there is no match ,NULL values are returned for the columns from first(left) table.