Chapter 16, Problem 2FTE

Explanation of Solution

Given SQL statement:

SELECT * FROM Coffee WHERE ProdNum != ‘14-001’

Not-equal-to operator in SQL:

In SQL not-equal-to operator is “< >”.

• The “< >” operator tests whether one expression is not equal to another expression.
• If any one of the operands or both of the operands are NULL, result is NULL.
• It returns true if both of them have different values.
• It returns false, in case if both values are equal.

SELECT:

• The “SELECT” statement is been used for selecting data from a database.
• The result table is stored with data and is termed as result set.
• All the fields present in table could be selected using “SELECT” statement.
• The “FROM” denotes a clause to choose from a table.
• The “WHERE” clause specifies that SQL statement should only affect rows with specified criteria.
• The criteria are expressed in form of predicates.
• It is not a mandatory clause, but is used to limit number of rows affected by SQL statement...