▶ C'mon over to https://realpars.com where you can learn PLC programming faster and easier than you ever thought possible!=============================▶ Check out the full blog post over at https://realpars.com/inner-join/=============================If you are just now joining along with this series of videos, please note that you are going to learn about SQL programming basics.If you would like to follow along with us, please review the RealPars video, “How to install MySQL and import a sample database”, on how to download and setup MySQL database on your computer.(https://realpars.com/mysql/)“What are SQL Where and Like statements basics” (https://realpars.com/sql-where/), continues where we left off within the “What are SQL programming basics” video for our series of lessons covering SQL programming.(https://realpars.com/sql/)In the previous video, What are the SQL Order By Clause and Expression statement language elements? (https://realpars.com/sql-order-by/),we learned about the structure of SQL defining the clauses, expressions defining the overall statement.In this video, you will learn about some of the more advanced SQL statements and clause commands such as Inner Join, AND, OR, Having, and Between. We will also learn more about the SQL syntax or rules of the SQL language.The AND operator is a logical operator that combines two or more Boolean expressions and returns true only if both expressions evaluate to true.The OR operator is a logical operator that combines two or more Boolean expressions and returns true when either condition is true.The BETWEEN operator is a logical operator that allows you to specify whether a value is in a range or not.The INNER JOIN clause matches rows in one table with rows in other tables and allows you to query rows that contain columns from both tables.The HAVING clause is used in the SELECT statement to specify filter conditions for a group of rows or aggregates.Now the department asks us to write the SQL statement, using the HAVING clause from the Order details table, with results displaying the Order number column data with two calculated columns for the quantity and total amount paid for each order only having totals greater than 1000 and quantity greater than 600.=============================Review the MySQL minimum hardware requirement web page here:https://forums.mysql.com/read.php?11,629199,629211Download the MySQL Installer:https://dev.mysql.com/downloads/installer/Download the sample database SQL file from here:https://realpars.com/wp-content/uploads/2019/12/realparssampledatabasev2.zipDownload the sample database diagram file from here:https://realpars.com/wp-content/uploads/2020/01/RealParsSampleDatabaseV2-Diagram.zip=============================Missed our most recent videos? Watch them here: https://realpars.com/p-id/https://realpars.com/profibus/=============================How to Install MySQL and Import a Sample Database (Part 1)https://realpars.com/mysqlWhat are SQL Programming Basics? (Part 2)https://realpars.com/sqlWhat are SQL Where and Like Statements Basics? (Part 3)https://realpars.com/sql-whereWhat are the SQL Order By Clause and Expression Statement Language Elements? (Part 4)https://realpars.com/sql-order-by/=============================To stay up to date with our last videos and more lessons, make sure to subscribe to this YouTube channel:http://goo.gl/Y6DRiN=============================TWEET THIS VIDEO https://ctt.ac/A5xN5=============================Like us on Facebook: https://www.facebook.com/therealpars/Follow us on Twitter: https://twitter.com/realparsFollow us on LinkedIn https://www.linkedin.com/company/realparsFollow us on Instagram https://www.instagram.com/realparsdotcom/#RealPars #SQL #MySQL - Electrical eng - 1396Phillip

What are the SQL Inner Join, And, Or, Having and Between Clause? (Part 5 of 8)

What are the SQL Inner Join, And, Or, Having and Between Clause? (Part 5 of 8)

Phillip Photo
Phillip
1 year
2 Views
Want to watch this again later?
Sign in to add this video to a playlist. Login
0 0
Category:
Electrical eng
Description:
▶ C'mon over to https://realpars.com where you can learn PLC programming faster and easier than you ever thought possible!

=============================

▶ Check out the full blog post over at https://realpars.com/inner-join/

=============================

If you are just now joining along with this series of videos, please note that you are going to learn about SQL programming basics.

If you would like to follow along with us, please review the RealPars video, “How to install MySQL and import a sample database”, on how to download and setup MySQL database on your computer.
(https://realpars.com/mysql/)

“What are SQL Where and Like statements basics” (https://realpars.com/sql-where/), continues where we left off within the “What are SQL programming basics” video for our series of lessons covering SQL programming.
(https://realpars.com/sql/)

In the previous video, What are the SQL Order By Clause and Expression statement language elements? (https://realpars.com/sql-order-by/),
we learned about the structure of SQL defining the clauses, expressions defining the overall statement.

In this video, you will learn about some of the more advanced SQL statements and clause commands such as Inner Join, AND, OR, Having, and Between. We will also learn more about the SQL syntax or rules of the SQL language.

The AND operator is a logical operator that combines two or more Boolean expressions and returns true only if both expressions evaluate to true.

The OR operator is a logical operator that combines two or more Boolean expressions and returns true when either condition is true.

The BETWEEN operator is a logical operator that allows you to specify whether a value is in a range or not.

The INNER JOIN clause matches rows in one table with rows in other tables and allows you to query rows that contain columns from both tables.

The HAVING clause is used in the SELECT statement to specify filter conditions for a group of rows or aggregates.

Now the department asks us to write the SQL statement, using the HAVING clause from the Order details table, with results displaying the Order number column data with two calculated columns for the quantity and total amount paid for each order only having totals greater than 1000 and quantity greater than 600.

=============================

Review the MySQL minimum hardware requirement web page here: https://forums.mysql.com/read.php?11 ,629199,629211

Download the MySQL Installer: https://dev.mysql.com/downloads/installer/

Download the sample database SQL file from here: https://realpars.com/wp-content/uploads/2019/12/realparssampledatabasev2.zip

Download the sample database diagram file from here: https://realpars.com/wp-content/uploads/2020/01/RealParsSampleDatabaseV2-Diagram.zip

=============================

Missed our most recent videos? Watch them here:
https://realpars.com/p-id/
https://realpars.com/profibus/

=============================

How to Install MySQL and Import a Sample Database (Part 1) https://realpars.com/mysql

What are SQL Programming Basics? (Part 2) https://realpars.com/sql

What are SQL Where and Like Statements Basics? (Part 3) https://realpars.com/sql-where

What are the SQL Order By Clause and Expression Statement Language Elements? (Part 4) https://realpars.com/sql-order-by/

=============================

To stay up to date with our last videos and more lessons, make sure to subscribe to this YouTube channel:
http://goo.gl/Y6DRiN

=============================

TWEET THIS VIDEO https://ctt.ac/A5xN5

=============================

Like us on Facebook: https://www.facebook.com/therealpars/

Follow us on Twitter: https://twitter.com/realpars

Follow us on LinkedIn https://www.linkedin.com/company/realpars

Follow us on Instagram https://www.instagram.com/realparsdotcom/

#RealPars #SQL #MySQL

Comments:

Comment
Up Next Autoplay