CODEWITHSUNDEEP
sqloracle-database
N.J
N.J

Reputation: 19

What does < variable, variable > mean?

I understand in SQL that <> means not equal to. Does is still mean the same thing if there are variables declared in between?

See below an example: 

where OBJECTNAME = 'example' and time > validdate and validtime < date;

Upvotes: 1

Views: 35

Answers (1)

Lukasz Szozda
Lukasz Szozda

Reputation: 175726

It is logical conjuction and comparison operators (> greater than, < less than).

WHERE OBJECTNAME = 'example' 
  AND time > validdate 
  AND validtime < date;

It means that all conditions have to be true to evaluate entire formula as true.

Upvotes: 2

Related Questions