SQL Examples

PostgreSQL tutorial for Beginners – PostgreSQL – DISTINCT Keyword

Hits: 7 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 …

Snowflake for Beginners – Convert Columns Into Rows

Hits: 296 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 …

Beginners Guide to R – R Vector

Hits: 14 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 …

SQL with Examples : SQL DELETE Statement

Hits: 20 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 …

SQL with Examples : SQL UPDATE Statement

Hits: 8 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 …

SQL with Examples : SQL INSERT SELECT Statement

Hits: 9 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 …

SQL with Examples : SQL INSERT INTO Statement

Hits: 8 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 …

SQL with Examples : SQL Aggregate Functions

Hits: 9 SQL Aggregate Functions It is often necessary to summarize data for analysis and reporting purposes. Be it determining the number of rows in a table, obtaining the sum of column’s values, or finding the column’s highest, lowest, or average value. Aggregate functions are used for this type of retrieval. Although each DBMS has …

SQL with Examples : SQL LIKE Operator

Hits: 3 SQL LIKE Operator Until now you have been using operators such as conditional operators (for testing equality), BETWEEN operator (for checking against a range of values) or IN operator (for checking against a set of values) in which one thing is common; They all search for an exact match. Filtering data that way is all well and good. But …