SQL SELECT Statement Quiz

WHERE

SELECT

FROM

JOIN

To modify data

To retrieve data

To delete data

To create a table

It increases the query speed

It limits the data affected by the query

It changes the database structure

It creates new tables

Not equal to

Less than

Equal to

Greater than

<=

>=

>

<

Numeric

Alphabetical

Random

Reverse alphabetical

orders

customers

products

employees

SELECT * FROM table_name;

SELECT ALL FROM table_name;

SELECT DATA FROM table_name;

SELECT COLUMNS FROM table_name;

Selects specific columns from the customers table

Selects all columns from the customers table

Deletes all data from the customers table

Updates all data in the customers table

Select all columns

Select a specific column

Select all rows

Select a specific row