'''Pinot'''
to match the string literal 'Pinot'
WHERE a='b'
means the predicate on the column a
equals to a string literal value 'b'
WHERE a="b"
means the predicate on the column a
equals to the value of the column b
timestamp
or date
) or special charactesr, you will need to use double quotes when referring to them in queries.Results might not be consistent if the order by column has the same value in multiple rows.
airlineName
starts with U