Logo

Go on. Explore!

lvl 0 • 0 xp

lvl 1

HomeMarketDecksInterests
SQL

SQL

memorize.aimemorize.ai (lvl 286)
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%
(0)
(0)
(0)
15 cards
()
Section 1

Preview this deck

LIKE operator

Front

1 / 15

SQL
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%

0.0

0 reviews

5
0
4
0
3
0
2
0
1
0

Active users

0

All-time users

0

Favorites

0

Last updated

5 years ago

Date created

Mar 1, 2020

Cards (15)

Section 1

(15 cards)

LIKE operator

Front

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.

Back