(SQL Tutorials for Citizen Data Scientist) SQL LIKE Operator In this tutorial you will learn how to retrieve the data based on a partial match. Pattern Matching So far, you’ve seen the conditions that identify an exact string, e.g. WHERE name=’Lois Lane’. But in SQL you can perform partial or pattern matching too using the LIKE operator. The LIKE operator provides a …

(SQL Tutorials for Citizen Data Scientist) SQL UNION Operation In this tutorial you will learn how to combine the results of two or more SQL queries. The UNION Operator The UNION operator is used to combine the results of two or more SELECT queries into a single result set. The union operation is different from using joins that combine columns from …

(SQL Tutorials for Citizen Data Scientist) SQL CROSS JOIN Operation In this tutorial you will learn how to fetch data from two tables using SQL cross join. Using Cross Joins If you don’t specify a join condition when joining two tables, database system combines each row from the first table with each row from the second table. …

(SQL Tutorials for Citizen Data Scientist) SQL FULL JOIN Statement In this tutorial you will learn how to retrieve data from two tables using SQL full join. Using Full Joins A FULL JOIN returns all the rows from the joined tables, whether they are matched or not i.e. you can say a full join combines the functions of a LEFT …

(SQL Tutorials for Citizen Data Scientist) SQL RIGHT JOIN Operation In this tutorial you will learn how to fetch data from two tables using SQL right join. Using Right Joins The RIGHT JOIN is the exact opposite of the LEFT JOIN. It returns all rows from the right table along with the rows from the left table for which the …

(SQL Tutorials for Citizen Data Scientist) SQL LEFT JOIN Operation In this tutorial you will learn how to retrieve data from two tables using SQL left join. Using Left Joins A LEFT JOIN statement returns all rows from the left table along with the rows from the right table for which the join condition is met. Left join is …

(SQL Tutorials for Citizen Data Scientist) SQL INNER JOIN Operation In this tutorial you will learn how to fetch data from two tables using SQL inner join. Using Inner Joins The INNER JOIN is the most common type of join. It returns only those rows that have a match in both joined tables. The following Venn diagram illustrates how inner …

(SQL Tutorials for Citizen Data Scientist) SQL Join Fundamentals All the queries you’ve seen so far have been concentrated on a single table. But in real life situation you often need to query two or more tables at time and bring a combined result set. This is technically referred to as a join, since it …

(SQL Tutorials for Citizen Data Scientist) SQL DROP Statement In this tutorial you will learn how to delete database and table using SQL. Removing a Table from Database You can use the DROP TABLE statement to easily delete the database tables that you no longer need. The DROP TABLE statement permanently erase all data from the table, as well as the …

(SQL Tutorials for Citizen Data Scientist) SQL TRUNCATE TABLE Statement In this tutorial you will learn how to quickly delete all rows from a table using SQL. Removing Table Data The TRUNCATE TABLE statement removes all the rows from a table more quickly than a DELETE. Logically, TRUNCATE TABLE is similar to the DELETE statement with no WHERE clause. The TRUNCATE TABLE statement removes all the rows from …