SQL Tutorials for Business Analyst

Learn to Code SQL Example – SQL | Intersect and Except clause

(SQL Example for Citizen Data Scientist & Business Analyst)   SQL | Intersect & Except clause 1. INTERSECT clause : As the name suggests, the intersect clause is used to provide the result of the intersection of two select statements. This implies the result contains all the rows which are common to both the SELECT statements. …

Learn to Code SQL Example – SQL | Union Clause

(SQL Example for Citizen Data Scientist & Business Analyst)   SQL | Union Clause The Union Clause is used to combine two separate select statements and produce the result set as a union of both the select statements. NOTE: The fields to be used in both the select statements must be in same order, same …

Learn to Code SQL Example – SQL | Wildcard operators

(SQL Example for Citizen Data Scientist & Business Analyst)   SQL | Wildcard operators In the above mentioned article WHERE Clause is discussed in which LIKE operator is also explained, where you must have encountered the word wildcards now lets get deeper into Wildcards. Wildcard operators are used with LIKE operator, there are four basic …

Learn to Code SQL Example – SQL | GROUP BY

(SQL Example for Citizen Data Scientist & Business Analyst)   SQL | GROUP BY The GROUP BY Statement in SQL is used to arrange identical data into groups with the help of some functions. i.e if a particular column has same values in different rows then it will arrange these rows in a group. Important …

Learn to Code SQL Example – SQL | Arithmetic Operators

(SQL Example for Citizen Data Scientist & Business Analyst)   SQL | Arithmetic Operators Arithmetic Operators are: + [Addition] – [Subtraction] / [Division] * [Multiplication] % [Modulus] Addition (+) : It is used to perform addition operation on the data items, items include either single column or multiple columns. Implementation: SELECT employee_id, employee_name, salary, salary + 100 AS …

Learn to Code SQL Example – SQL | ALL and ANY

(SQL Example for Citizen Data Scientist & Business Analyst) SQL | ALL and ANY ALL & ANY are logical operators in SQL. They return boolean value as a result. ALL ALL operator is used to select all tuples of SELECT STATEMENT. It is also used to compare a value to every value in another value set …

Learn to Code SQL Example – SQL | WITH clause

(SQL Example for Citizen Data Scientist & Business Analyst) SQL | WITH clause The SQL WITH clause was introduced by Oracle in the Oracle 9i release 2 database. The SQL WITH clause allows you to give a sub-query block a name (a process also called sub-query refactoring), which can be referenced in several places within …

SQL tutorials for Business Analyst – SQL | Date Functions

  SQL tutorials for Business Analyst – SQL | Date Functions   The following table has a list of all the important Date and Time related functions available through SQL. There are various other functions supported by your RDBMS. The given list is based on MySQL RDBMS. Sr.No. Function & Description 1 ADDDATE()Adds dates 2 …

SQL tutorials for Business Analyst – SQL | Wildcard Operators

  SQL tutorialsfor Business Analyst SQL| Wildcard Operators We have already discussed about the SQL LIKE operator, which is used to compare a value to similar values using the wildcard operators. SQL supports two wildcard operators in conjunction with the LIKE operator which are explained in detail in the following table. Sr.No. Wildcard & Description …