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)
25 cards
()
Section 1

Preview this deck

SELECT column1, column2, ... FROM table_name WHERE condition1 OR condition2 OR condition3 ...;

Front

1 / 25

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

6 years ago

Date created

Mar 14, 2020

Cards (25)

Section 1

(25 cards)

SELECT column1, column2, ... FROM table_name WHERE condition1 OR condition2 OR condition3 ...;

Front

OR Syntax

Back

SELECT column1, column2, ... FROM table_name WHERE condition;

Front

Syntax for WHERE when using SELECT

Back

= Equal <> Not Equal > Greater than < Less than >= Greater than or equal <= Less than or equal

Front

Basic Operators in the WHERE clause:

Back

SELECT * FROM table_name;

Front

Syntax to select all records in a table?

Back

SELECT column1, column2, ... FROM table_name;

Front

Syntax to select specific records in a table?

Back

semicolon

Front

A __________________ is the standard way to separate each SQL statement in database systems that allow more than one SQL statement to be executed in the same call to the server.

Back

SELECT DISTINCT

Front

This statement is used to return only distinct (different) values

Back

WHERE

Front

This clause is used to filter records and extracts only those records that fulfill a specified condition.

Back

result-set

Front

The data returned from a SQL Statement is stored in a result table, called the __________________.

Back

No

Front

Are SQL keywords case sensitive?

Back

SELECT DISTINCT column1, column2, ... FROM table_name;

Front

Syntax for SELECT DISTINCT

Back

table

Front

The data in RDBMS is stored in database objects called ______________; which is a collection of related data entries and it consists of columns and rows.

Back

record (aka row)

Front

A ____________ is each individual horizontal entry that exists in a table.

Back

SELECT COUNT (DISTINCT column_name) FROM table_name;

Front

Syntax for returning the actual count of different/distinct values

Back

SELECT column1, column2, ... FROM table_name WHERE condition1 AND condition2 AND condition3 ...;

Front

AND Syntax

Back

SELECT

Front

This statement is used to select data from a database.

Back

SELECT column1, column2, ... FROM table_name WHERE NOT condition;

Front

NOT Syntax

Back

column

Front

A ______________ is a vertical entity in a table that contains all information associated with a specific field in a table.

Back

AND

Front

Typically using in conjunction with the WHERE clause, the ___________ operator displays a record if all the conditions separated by "AND" are TRUE.

Back

Structured Query Language (SQL)

Front

What does SQL stand for?

Back

NOT

Front

Typically using in conjunction with the WHERE clause, the _________ operator displays a record if the condition(s) is NOT TRUE.

Back

Standard language that lets you access and manipulate databases

Front

What is SQL?

Back

relational database management system

Front

What does RDBMS stand for?

Back

OR

Front

Typically using in conjunction with the WHERE clause, the ___________ operator displays a record if all the conditions separated by "OR" are TRUE.

Back

fields

Front

Every table is broken up into smaller entities called ______________; which is a column in a table that is designed to maintain specific information about every record in the table.

Back