Scribd
Upload
9 views3 pages

Chapter 2

The document outlines various operators used in arithmetic, comparison, and logical operations, including basic and advanced logical operators. It provides examples of functions like MAX, MIN, AVG, and others, along with their syntax. Additionally, it mentions the use of GROUP BY and HAVING clauses in SQL queries.

Uploaded by

zkllkz07
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
9 views3 pages

Chapter 2

The document outlines various operators used in arithmetic, comparison, and logical operations, including basic and advanced logical operators. It provides examples of functions like MAX, MIN, AVG, and others, along with their syntax. Additionally, it mentions the use of GROUP BY and HAVING clauses in SQL queries.

Uploaded by

zkllkz07
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Arithmetic operator Comparison operator

T =

* <
not equal
/ E

Basic
E
logical operator
AND

OR
NOT

Advanced logical operator example


field INC'X', 'Y'
-
IN
BETWEEN number AND number
-
... AND...
BETWEEN
LIKE % XXX
-

-
LIKE field
-
IS NULL field IS NULL
-
SPACE SPACE (number (
-
MAX MAX (fields
-
MIN MIN (fields
-
AVG AVG (field)
~
UPPER UPPER (field>
-

LWER LOWER (fields


-
COUNT COUNT (field
TRIM > To remove
space TRIM (fields
-
-

As .... As name

-
INT INT (fields
-
ABS ABS (field (
of characters LEN Cfields
-
LEN-count the
length
-
SUBSTRING SUBSTRING (field or
string ,
start position ,

number of character (
-

Group by group by field (

Having Having critrion


-

use
having after
group by
-
Month Month (field ,
TEAR <field
"Date
-
EAR
-
Date 2 field

Day(field number
DAY a
-

- Char (

Order
select >
-
from >
- where >
-

group by >
-

Having

You might also like