SQL Mastery: A Comprehensive Guide to Executing Common Excel Operations with SQL
In-Depth Guide to Star Schema in Data Warehouse Modelling: Concepts, Design Principles, and Advantages
PostgreSQL – DISTINCT Keyword The PostgreSQL DISTINCT keyword is used in conjunction with SELECT statement to eliminate all the duplicate records and fetching only unique records. There may be a situation when you have multiple duplicate records in a table. While fetching such records, it makes more sense to fetch only unique records instead of fetching …
Convert Columns Into Rows UNPIVOT converts a table’s columns into rows. Create Table Of Superheroes – Create a table called SUPERHEROES. CREATE OR REPLACE TABLE SUPERHEROES ( “ALTER_EGO” VARCHAR(100), “AGE” INT, “2015” INT, “2016” INT, “2017” INT, “2018” INT, “2019” INT ); Insert Rows For Each Superhero – Insert rows into SUPERHEROES INSERT INTO SUPERHEROES VALUES …
R Vector A vector is a collection of elements, all the same type (similar to an array in other programming languages but more versatile). When using R, you will frequently encounter the four basic vector types viz. logical, character, integer and double (often called numeric). Create a vector In R, there are several ways to …
SQL DELETE Statement The DELETE statement is used to delete data from a table. It can be used in two ways: To delete specific rows from a table To delete all rows from a table Now let’s take a look at each of these in detail. Syntax DELETE FROM table_name WHERE condition; Sample Table To …
SQL UPDATE Statement The UPDATE statement allows you to update existing rows with new values. With it, you can change the value of one or more columns in each row that meets the search condition of the WHERE clause. Syntax The UPDATE statement is made up of three parts: The table you want to update …
SQL INSERT SELECT Statement INSERT statement is commonly used to insert a row into a table using specified values. There is a second form of INSERT that inserts the result of a SELECT statement in a table, known as INSERT SELECT. As its name suggests, it is made up of an INSERT statement and a SELECT …
SQL INSERT INTO Statement The INSERT INTO statement allows you to insert one or more new rows into a table. Using the INSERT INTO statement, it is possible to insert a complete row, a partial row, multiple rows or rows generated as the result of a query. Let’s now take a look at each of …
SQL HAVING Clause In addition to creating groups using GROUP BY clause, you can also decide which groups to include in the output and which to exclude. For example, you might want a list of jobs for which more than one employee is hired. To get this kind of data you have to filter by …