(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. …