SQL for Beginners

SQL tutorials for Business Analyst – SQL | SORTING Results

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

SQL tutorials for Business Analyst – SQL | Group By

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

SQL tutorials for Business Analyst – SQL | ORDER BY Clause

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

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

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

SQL tutorials for Business Analyst – SQL | LIKE Clause

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

SQL tutorials for Business Analyst – SQL | DELETE Query

Hits: 25 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | DELETE Query.   The SQL DELETE Query is used to delete the existing records from a table. You can use the WHERE clause with a DELETE query to delete the selected …

SQL tutorials for Business Analyst – SQL | UPDATE Query

Hits: 16 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | UPDATE Query.   The SQL UPDATE Query is used to modify the existing records in a table. You can use the WHERE clause with the UPDATE query to update the selected rows, otherwise …

SQL tutorials for Business Analyst – SQL | AND and OR Conjunctive Operators

Hits: 13 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | AND and OR Conjunctive Operators.   The SQL AND & OR operators are used to combine multiple conditions to narrow data in an SQL statement. These two operators are called as the conjunctive operators. These …

SQL tutorials for Business Analyst – SQL | WHERE Clause

Hits: 35 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | WHERE Clause.   The SQL WHERE clause is used to specify a condition while fetching the data from a single table or by joining with multiple tables. If the given condition is satisfied, …

SQL tutorials for Business Analyst – SQL | SELECT Query

Hits: 14 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | SELECT Query.   The SQL SELECT statement is used to fetch the data from a database table which returns this data in the form of a result table. These result tables are called …

SQL tutorials for Business Analyst – SQL | INSERT Query

Hits: 19 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | INSERT Query.   The SQL INSERT INTO Statement is used to add new rows of data to a table in the database. Syntax There are two basic syntaxes of the INSERT INTO statement …

SQL tutorials for Business Analyst – SQL | DROP or DELETE Table

Hits: 14 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | DROP or DELETE Table.   The SQL DROP TABLE statement is used to remove a table definition and all the data, indexes, triggers, constraints and permission specifications for that table. NOTE − You should …

SQL tutorials for Business Analyst – SQL | CREATE Table

Hits: 17 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | CREATE Table.   Creating a basic table involves naming the table and defining its columns and each column’s data type. The SQL CREATE TABLE statement is used to create a new table. Syntax …

SQL tutorials for Business Analyst – SQL | SELECT Database, USE Statement

Hits: 14 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | SELECT Database, USE Statement.   When you have multiple databases in your SQL Schema, then before starting your operation, you would need to select a database where all the operations would …

SQL tutorials for Business Analyst – SQL | DROP or DELETE Database

Hits: 9 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | DROP or DELETE Database.   The SQL DROP DATABASE statement is used to drop an existing database in SQL schema. Syntax The basic syntax of DROP DATABASE statement is as follows − DROP …