Filtering Data in SQL Select Statement | Comparison, Logical, and Special Operators in SQL PT

Опубликовано: 11 Август 2022
на канале: Parnika Tutorials
322
9

"Oracle - SQL Filtering Data in SQL Select Statement | Comparison, Logical, and Special Operators in SQL

#sql #parnikatutorials #selectstatement
#SQLFilteringData #SQLSelectStatement #sqlComparisonOperators #sqlLogicalOperators #sqlSpecialOperators #sqlOperators #Operators #SpecialOperators #LogicalOperators #ComparisonOperators
#sqlserver #sqldata#SQLFullCourse #SQLTutorialForBeginners #LearnSQL #SQLTutorialFullDatabaseCourseforBeginners #StructuredQueryLanguage #SQLforBeginners #CompleteMySQLBeginnertoExpert #OracleSQLforBeginners #SQLcompletetutorialforBeginners

00:13 - comparison operators
10:01 - logical operators
15:27 - special operators
22:35 - like operators"

In this video, I have discussed filtering of data in select statement
#sql #parnikatutorials #selectstatement

A comparison (or relational) operator is a mathematical symbol which is used to compare two values.

Comparison operators are used in conditions that compares one expression with another. The result of a comparison can be TRUE, FALSE, or UNKNOWN (an operator that has one or two NULL expressions returns UNKNOWN).

SQL logical operators are used to test for the truth of the condition. A logical operator like the Comparison operator returns a boolean value of TRUE, FALSE, or UNKNOWN.

Given below is the list of logical operators available in SQL.
Operator Meaning
AND TRUE if both Boolean expressions are TRUE.
OR TRUE if either Boolean expression is TRUE.
NOT Reverses the value of any other Boolean operator.

Social media Links:
Instagram:   / parnikatutorials  
Website: http://parnikatutorials.in/
Email id: [email protected]
To get the regular updates:
Telegram link: https://t.me/Parnikatutorials
Facebook: https://m.facebook.com/profile.php?id...
Linkedin:   / parnika-tutorials-a8a9831b2  
Pinterest:   / parnikatutorials0892  
Playlists:
Virtual Coffee with Jagadeesh:
   • VIRTUAL COFFEE WITH JAGADEESH  
Digital Logic Design:
   • Digital Logic Design  
Computer Organization and Architecture:
   • ABOUT PARNIKA TUTORIALS  
C Programming:
   • L 1: WHAT IS AN ALGORITHM AND CHARACT...  
Data Structures:
   • L 1: Uncover the Benefits of Linked L...  

Theory of Computation:
   • ABOUT PARNIKA TUTORIALS  

Compiler Design:
   • ABOUT PARNIKA TUTORIALS  
Operating Systems:    • PROCESS STATE DIAGRAM | LONG TERM, SH...  

Databases:    • ABOUT PARNIKA TUTORIALS