SQL Clauses Part -II | BETWEEN, IN, LIKE, IS NULL, GROUP BY, ORDER BY, HAVING Clauses with Examples

Опубликовано: 25 Июль 2024
на канале: Learn with Nivas

130

This video is a continuation to the previous video SQL Clauses Part I link is provided below, we have covered the Explanation of the following Clauses in detail with examples executed on SQL Server for your understanding.

1. Comparison Operators
2. BETWEEN Condition
3. IN Condition
4. LIKE Condition
5. IS NULL Condition
6. GROUP BY Clause
7. ORDER BY Clause
8. HAVING Clause

Reference Videos :

SQL Clauses Part I :    • SQL Clauses Part - I | AND, OR, NOT, CASE ...

SQL Left Outer Join :    • SQL Joins for Beginners | Left Outer Join ...

SQL Right Outer Join :    • SQL Joins for Beginners | Right Outer Join...

SQL Basics & Aggregate Function :    • SQL Basics Part - II | Explanation of Aggr...

SQL Server Installation :    • How to Install SQL Server 2022 Database in...

SQL Server Management Studio (SSMS) Installation :    • How to Install SQL Server Management Studi...

Chapters in this video are as under:

0:00 Introduction to SQL Clauses Part - II
0:23 How to use Comparison Operations in SQL Query
1:14 Execution and Example of Comparison Operators in SQL Server
2:47 Syntax of Comparison Operators in SQL
3:25 Explanation for BETWEEN Condition in SQL
4:09 Syntax and Example for BETWEEN Condition in SQL
5:06 Execution of BETWEEN Condition in SQL Server
12:37 Explanation of IN Condition in SQL
13:29 Syntax and Example for IN Condition in SQL
14:32 Execution of IN Condition in SQL Server
15:19 Explanation and Execution of NOT IN Condition in SQL Server
16:06 Explanation for LIKE Condition in SQL
18:06 Syntax and Example for LIKE Condition in SQL
19:24 Execution of LIKE Condition in SQL Server
28:31 Explanation of IS NULL Condition in SQL
29:01 Syntax and Example for IS NULL Condition in SQL
29:58 Execution for IS NULL Condition in SQL Server
30:51 Explanation for GROUP BY Clause in SQL
31:43 Syntax and Example for GROUP BY Clause in SQL
32:22 Execution of GROUP BY Clause in SQL Server
33:08 Explanation for ORDER BY Clause in SQL
33:40 Syntax and Example for ORDER BY Clause in SQL
34:37 Execution of ORDER BY Clause in SQL Server
35:41 Explanation for HAVING Clause in SQL
36:41 Syntax and Example for HAVING Clause in SQL
37:46 Execution of HAVING Clause in SQL Server

/* COMPARISON OPERATORS EXAMPLE */

Please refer the video, the query is not pasted here due to restriction

/* BETWEEN CONDITION EXAMPLE */

SELECT PRODUCT_ID, PRODUCT_NAME, PRODUCT_QUANTITY, PRODUCT_PRICE, PRODUCT_COUNTRY
FROM SUPPLIER_A
WHERE PRODUCT_PRICE BETWEEN 20 AND 50

/* IN CONDITION EXAMPLE */

SELECT PRODUCT_ID, PRODUCT_NAME, PRODUCT_QUANTITY, PRODUCT_PRICE, PRODUCT_COUNTRY
FROM SUPPLIER_A
WHERE PRODUCT_PRICE IN (20,45)

/* LIKE CONDITION EXAMPLE */

SELECT PRODUCT_ID, PRODUCT_NAME, PRODUCT_QUANTITY, PRODUCT_PRICE, PRODUCT_COUNTRY
FROM SUPPLIER_A
WHERE PRODUCT_COUNTRY LIKE 'BR%'

/* IS NULL CONDITION EXAMPLE */

SELECT A.PRODUCT_ID, A.PRODUCT_NAME, B.PRODUCT_ID, B.PRODUCT_NAME
FROM SUPPLIER_A A
LEFT OUTER JOIN SUPPLIER_B B
ON A.PRODUCT_ID = B.PRODUCT_ID
WHERE B.PRODUCT_ID IS NULL

/* GROUP BY CLAUSE EXAMPLE */

SELECT PRODUCT_COUNTRY,COUNT(PRODUCT_ID)
FROM SUPPLIER_A
GROUP BY PRODUCT_COUNTRY

/* ORDER BY CLAUSE EXAMPLE */

SELECT PRODUCT_COUNTRY,COUNT(PRODUCT_ID)
FROM SUPPLIER_A
GROUP BY PRODUCT_COUNTRY
ORDER BY COUNT(PRODUCT_ID) ASC

/* HAVING CLAUSE EXAMPLE */

Please refer the video, the query is not pasted here due to restriction

/* COMMAND FOR ALTERING THE TABLE TO ADD NEW COLUMN LAST_UPDATED AND POPULATING ITS VALUES */

ALTER TABLE SUPPLIER_A ADD LAST_UPDATED DATETIME

SELECT * FROM SUPPLIER_A

UPDATE SUPPLIER_A SET LAST_UPDATED = '2024-07-22'
WHERE PRODUCT_COUNTRY = 'BRAZIL'

UPDATE SUPPLIER_A SET LAST_UPDATED = '2024-07-22'
WHERE PRODUCT_COUNTRY = 'INDIA'

UPDATE SUPPLIER_A SET LAST_UPDATED = '2024-07-20'
WHERE PRODUCT_COUNTRY = 'SOUTH AFRICA'

UPDATE SUPPLIER_A SET LAST_UPDATED = '2024-07-23'
WHERE PRODUCT_COUNTRY = 'SPAIN'

UPDATE SUPPLIER_A SET LAST_UPDATED = '2024-07-10'
WHERE PRODUCT_COUNTRY = 'ECUADOR'

UPDATE SUPPLIER_A SET LAST_UPDATED = '2024-07-21'
WHERE PRODUCT_COUNTRY = 'NETHERLANDS'