W3. SQL Select

Question 1

Q: What does the SQL SELECT statement do?

Answer 1

A: It selects data from a database.

Question 2

Q: Write a SELECT statement to return CustomerName and City from the Customers table.

Answer 2

SELECT CustomerName, City FROM Customers;

Question 3

Q: What is the syntax for a basic SELECT statement?

Answer 3

SELECT column1, column2, …
FROM table_name;

Question 4

Q: In the SELECT statement, what does table_name represent?

Answer 4

A: It represents the name of the table from which data is being selected.

Question 5

Q: How do you select all columns from a table without listing each column name?

Answer 5

A: Use SELECT *.

Question 6

Q: Write a query to select all columns from the Customers table.

Answer 6

SELECT * FROM Customers;