It allows you to specify partial character strings in a "wildcard" sense.
Back
OR operator
Front
It displays a record if either the first condition OR the second condition is true.
Back
JOIN clause
Front
It is used to combine rows from more than one table, based on a common field between them.
Back
Data management
Front
There are two aspects of data management: data definition and data manipulation.
Back
BETWEEN operator
Front
It allows you to specify a range of numeric values in a search.
Back
DISTINCT operator
Front
It is used to eliminate duplicate rows in a query result.
Back
IN operator
Front
It allows you to specify a list of character strings to be included in a search.
Back
SELECT command
Front
Data retrieval in SQL is accomplished with the SELECT command.
Back
Data definition
Front
It is operationalized with a data definition language (DDL), involves instructing the DBMS software on what tables will be in the database, what attributes will be in the tables, which attributes will be indexed, and so forth.
Back
Structured Query Language
Front
It is a standard language for data management in relational databases, known as Structured Query Language or SQL.
Back
Subquery
Front
When one SELECT statement is "nested" within another in a format, it is known as subquery.
Back
ORDER BY clause
Front
It simply takes the results of a SQL query and orders them by one or more specified attributes.
Back
* in the SELECT clause
Front
It indicates that all attributes of the selected row are to be retrieved.
Back
AVG() function
Front
It returns the average value of a numeric column.
Back
AND operator
Front
It displays a record if more than one condition is true.