Difference between revisions of "SQL Logical operators"

From Recital Documentation Wiki
Jump to: navigation, search
 
(2 intermediate revisions by one user not shown)
Line 1: Line 1:
=SQL LOGICAL OPERATORS=
 
 
 
==Class==
 
SQL Applications
 
 
 
 
==Purpose==
 
==Purpose==
 
Logical Operators
 
Logical Operators
Line 42: Line 35:
 
<code lang="recital">
 
<code lang="recital">
 
// AND
 
// AND
EXEC SQL
+
SELECT name, address, balance, cost*1.15;
SELECT name, address, balance, cost*1.15
+
FROM accounts;
FROM accounts
+
WHERE paid_date < date() AND ord_value > 10000;
WHERE paid_date < date() AND ord_value > 10000
+
ORDER BY name, paid_date
ORDER BY name, paid_date;
+
  
 
// NOT
 
// NOT
EXEC SQL
+
SELECT name, address, balance, cost*1.15;
SELECT name, address, balance, cost*1.15
+
FROM accounts;
FROM accounts
+
WHERE paid_date < date() AND NOT ord_value BETWEEN 0 AND 10000;
WHERE paid_date < date() AND NOT ord_value BETWEEN 0 AND 10000
+
ORDER BY name, paid_date
ORDER BY name, paid_date;
+
  
 
// OR
 
// OR
EXEC SQL
+
SELECT name, address, balance, cost*1.15;
SELECT name, address, balance, cost*1.15
+
FROM accounts;
FROM accounts
+
WHERE paid_date < date() OR ord_value > 10000;
WHERE paid_date < date() OR ord_value > 10000
+
ORDER BY name, paid_date
ORDER BY name, paid_date;
+
  
 
// XOR
 
// XOR
EXEC SQL
+
SELECT name, address, balance, cost*1.15;
SELECT name, address, balance, cost*1.15
+
FROM accounts;
FROM accounts
+
WHERE paid_date < date() OR ord_value > 10000;
WHERE paid_date < date() OR ord_value > 10000
+
ORDER BY name, paid_date
ORDER BY name, paid_date;
+
 
</code>
 
</code>
  
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:SQL|Operators,Logical]]
 
[[Category:SQL|Operators,Logical]]

Latest revision as of 15:48, 5 July 2011

Purpose

Logical Operators


Syntax

<condition1> AND <condition2> NOT <condition> <condition1> OR <condition2> <condition1> XOR <condition2>


See Also

INSERT, SQL OPERATORS, SELECT, UPDATE


Description

Operator Description
AND True if <condition1> and <condition2> conditions are both true, otherwise False
NOT True if the <condition> is false, otherwise False
OR True if <condition1> or <condition2> is true or if both conditions are true, otherwise False
XOR True if <condition1> or <condition2> is true but not both, otherwise False


Example

// AND
SELECT name, address, balance, cost*1.15;
FROM accounts;
WHERE paid_date < date() AND ord_value > 10000;
ORDER BY name, paid_date
 
// NOT
SELECT name, address, balance, cost*1.15;
FROM accounts;
WHERE paid_date < date() AND NOT ord_value BETWEEN 0 AND 10000;
ORDER BY name, paid_date
 
// OR
SELECT name, address, balance, cost*1.15;
FROM accounts;
WHERE paid_date < date() OR ord_value > 10000;
ORDER BY name, paid_date
 
// XOR
SELECT name, address, balance, cost*1.15;
FROM accounts;
WHERE paid_date < date() OR ord_value > 10000;
ORDER BY name, paid_date


Products

Recital, Recital Server