FIT1004 Lecture 5: Predicates + Search Conditions
Lecture 5: Predicates, Search Conditions
BETWEEN
● used for checking whether the values falls between a particular range
● Ei : List student name of all students who have marks in the range of 60 to 70
LIKE
● pattern matching
● % - one or more characters
● _ - exactly one character
● symbols can be before & after
● Ei : List the student's surname, firstname and address for those students who have
surname starts with the letter 'S' and firstname contains the letter 'i'