Month: September 2020

Excel formula for Beginners – How to Sort by two columns in Excel

(Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to Sort by two columns in Excel.   Excel formula for Beginners – How to Sort by two columns in Excel Generic formula =SORTBY(data,col1,order,col2,order) Summary To sort by two columns, you can use the SORTBY function. In …

Excel formula for Beginners – How to Sort by random in Excel

(Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to Sort by random in Excel.   Excel formula for Beginners – How to Sort by random in Excel Generic formula =SORTBY(rng,RANDARRAY(COUNTA(rng))) Summary To sort a list or table in random order, you can use the SORTBY …

SQL tutorials for Business Analyst – SQL | INNER JOINS

(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 combining column …

SQL tutorials for Business Analyst – SQL | Using Joins

(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 values common …

SQL tutorials for Business Analyst – SQL | SORTING Results

(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 ascending order …

SQL tutorials for Business Analyst – SQL | Distinct Keyword

(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 have multiple …

SQL tutorials for Business Analyst – SQL | Group By

(SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | Group By.   The SQL GROUP BY clause is used in collaboration with the SELECT statement to arrange identical data into groups. This GROUP BY clause follows the WHERE clause in a SELECT statement and …

SQL tutorials for Business Analyst – SQL | ORDER BY Clause

(SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | TOP, LIMIT or ROWNUM Clause.   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 …

SQL tutorials for Business Analyst – SQL | TOP, LIMIT or ROWNUM Clause

(SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | TOP, LIMIT or ROWNUM Clause.   The SQL TOP clause is used to fetch a TOP N number or X percent records from a table. Note − All the databases do not support the TOP clause. …

SQL tutorials for Business Analyst – SQL | LIKE Clause

(SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | LIKE Clause.   The SQL LIKE clause is used to compare a value to similar values using wildcard operators. There are two wildcards used in conjunction with the LIKE operator. The percent sign (%) The …