Introduction to SQL (Part II)

Front

What are the basic data manipulation commands in SQL?

Back

INSERT, SELECT, UPDATE, and DELETE.

Front

What is the syntax for adding new rows to a table using INSERT?

Back

INSERT INTO table_name (columns) VALUES (values);

Front

Provide an example of an INSERT command.

Back

INSERT INTO Students (LastName, Section) VALUES ('Reyes', 'IT102');

Front

How do you add new records to all columns of a table?

Back

INSERT INTO table_name VALUES (values);

Front

What is the syntax to retrieve values from a table using SELECT?

Back

SELECT columns FROM table_name;

Front

How do you select all columns from a table?

Back

SELECT * FROM table_name;

Front

What does the DISTINCT operator do in SQL?

Back

It retrieves unique values from columns in a table.

Front

What is the syntax for using DISTINCT with SELECT?

Back

SELECT DISTINCT columns FROM table_name;

Front

Provide an example of using DISTINCT in a SELECT command.

Back

SELECT DISTINCT Section FROM Students;

Front

What is the purpose of the WHERE clause in SQL?

Back

To filter the rows of data based on provided criteria.