Basic SQL Grammar

Finally, you need to know some basic SQL syntax, including signs that let you construct a valid SQL statement. These are some commonly used signs:

Sign

Means

Examples

=

The value stored in the column matches the value entered to the right of the equal sign.

circ_privilege = 0

location = “main”

< >

The value stored in the column matches those less than or greater than the value entered to the right of the less than or greater than sign.

circ_privilege < 4

borrower# > 150

“”

Quotation marks surround a coded or free text value.

location = “main”

borrower_name = “wilson”

 


© 1998-2017 Sirsi Corporation