Comparison operators: Comparison operators allow row retrieval from table based on the condition specified in the WHERE clause.
Here is the list of all comparison operators available in SQL.
|>=||Greater than or equal to|
|<=||Less than or equal to|
|<>, !=||Not equal to|
|!>||Not greater than|
|<!||Not Less than|
Example: SELECT * from publishers WHERE country = 'USA'
The above statement displays those pub_name from publishers table for which country is USA.
Example: SELECT Type, Title_ID, Price from Titles WHERE Price * Ytd_Sales < Advance
This statement displays only those records from the Titles table in which the product of price and YtdSales attributes is less than the advance for the book.