Use of OR Operator in SQL

Use of OR Operator in SQL:

(1) “OR” operator is used where multiple conditions are executed. It shows records if any of the condition is true.

(2) Syntax of “OR” statement is:

SELECT DISTINCT column1, column2, …
FROM table_name
WHERE Cond1 OR Cond2 OR CondN;

(3) Let’s take an example to get records according to the “No.” & “Country Region Code” columns are equal to the assigned values as shown.

(4) Select the database in the SQL server and click on the “New Query” button as shown.

select database for selecting records in sql

(5) After that new query editor open as shown.

new query editor open in sql

(6) After doing the above steps, write a query in the editor, as shown.

OR Operator query in SQL

Source Code:

–// Without “OR” operator in Vendor table
Select [No_],[Name],[Address],[Country_Region Code] from dbo.[CRONUS India Ltd_$Vendor$437dbf0e-84ff-417a-965d-
ed2bb9650972]
–// Without “OR” operator in Vendor table
–// With “OR” operator in Vendor table
Select [No_],[Name],[Address],[Country_Region Code] from dbo.[CRONUS India Ltd_$Vendor$437dbf0e-84ff-417a-965d-
ed2bb9650972]
where [No_] = ‘01905283’ or [Country_Region Code] = ‘US’
–// With “OR” operator in Vendor table

(7) After writing the query, then execute the query (Shortcut keys is F5) as shown.

execute OR Operator query in SQL

(8) After executing the two queries in the same editor, SQL gives two results. Note: Recommended write and execute query one by one for reporting.


Use of AND operator in SQL
How to add or show new field in existing Page in D365 BC
Issue in Installing AL Symbol in VS editor [Solved]
How to Install AL code extension in VS Editor
Getting Started with AL– Microsoft Docs

Leave a Reply

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock