Tag Archives: SQL Examples

SQL tutorials for Business Analyst – SQL | Having Clause

Hits: 52 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | Having Clause.   SQL tutorials for Business Analyst – SQL | Having Clause   The HAVING Clause enables you to specify conditions that filter which group results appear in the results. The WHERE …

SQL tutorials for Business Analyst – SQL | Using Views

Hits: 29 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | Using Views.   A view is nothing more than a SQL statement that is stored in the database with an associated name. A view is actually a composition of a table …

SQL tutorials for Business Analyst – SQL | TRUNCATE TABLE

Hits: 24 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | TRUNCATE TABLE.   The SQL TRUNCATE TABLE command is used to delete complete data from an existing table. You can also use DROP TABLE command to delete complete table but it would remove …

SQL tutorials for Business Analyst – SQL | ALTER TABLE

Hits: 14 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | ALTER TABLE.   The SQL ALTER TABLE command is used to add, delete or modify columns in an existing table. You should also use the ALTER TABLE command to add and drop various …

SQL tutorials for Business Analyst – SQL | Indexes

Hits: 26 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | Indexes.   Indexes are special lookup tables that the database search engine can use to speed up data retrieval. Simply put, an index is a pointer to data in a table. An index …

SQL tutorials for Business Analyst – SQL | Alias Syntax

Hits: 24 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | Alias Syntax.   You can rename a table or a column temporarily by giving another name known as Alias. The use of table aliases is to rename a table in a specific …

SQL tutorials for Business Analyst – SQL | EXCEPT Clause

Hits: 16 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | EXCEPT Clause.   The SQL EXCEPT clause/operator is used to combine two SELECT statements and returns rows from the first SELECT statement that are not returned by the second SELECT statement. This means EXCEPT …

SQL tutorials for Business Analyst – SQL | INTERSECT Clause

Hits: 19 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | NTERSECT Clause.   The SQL INTERSECT clause/operator is used to combine two SELECT statements, but returns rows only from the first SELECT statement that are identical to a row in the second SELECT …

SQL tutorials for Business Analyst – SQL | UNIONS CLAUSE

Hits: 31 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | UNIONS CLAUSE.   The SQL UNION clause/operator is used to combine the results of two or more SELECT statements without returning any duplicate rows. To use this UNION clause, each SELECT …

SQL tutorials for Business Analyst – SQL | RIGHT JOINS

Hits: 9 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | RIGHT JOINS.   The SQL RIGHT JOIN returns all rows from the right table, even if there are no matches in the left table. This means that if the ON clause matches 0 …

SQL tutorials for Business Analyst – SQL | LEFT JOINS

Hits: 19 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | LEFT JOINS.   The SQL LEFT JOIN returns all rows from the left table, even if there are no matches in the right table. This means that if the ON clause matches 0 …

SQL tutorials for Business Analyst – SQL | INNER JOINS

Hits: 19 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | INNER JOINS.   The most important and frequently used of the joins is the INNER JOIN. They are also referred to as an EQUIJOIN. The INNER JOIN creates a new result table by …

SQL tutorials for Business Analyst – SQL | Using Joins

Hits: 12 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | Using Joins.   The SQL Joins clause is used to combine records from two or more tables in a database. A JOIN is a means for combining fields from two tables by using …

SQL tutorials for Business Analyst – SQL | SORTING Results

Hits: 15 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | SORTING Results.   The SQL ORDER BY clause is used to sort the data in ascending or descending order, based on one or more columns. Some databases sort the query results in an …

SQL tutorials for Business Analyst – SQL | Distinct Keyword

Hits: 13 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | Distinct Keyword.   The SQL DISTINCT keyword is used in conjunction with the SELECT statement to eliminate all the duplicate records and fetching only unique records. There may be a situation when you …