It is most common type of query. It retrieves records from one or more tables and then displays the A. Parameter B. Select C. crosstab D. All of above

The correct answer is: B. Select

A select query is a query that retrieves data from one or more tables in a database. The results of a select query are displayed in a table.

A parameter query is a query that allows you to enter a value when you run the query. The value you enter is used to filter the results of the query.

A crosstab query is a query that summarizes data in a table. The results of a crosstab query are displayed in a table with columns and rows.

Here is an example of a select query:

sql
SELECT * FROM Customers;

This query will retrieve all rows and columns from the Customers table.

Here is an example of a parameter query:

sql
SELECT * FROM Customers WHERE City = @City;

This query will retrieve all rows from the Customers table where the City column is equal to the value you enter for the @City parameter.

Here is an example of a crosstab query:

sql
SELECT CustomerName, City, COUNT(*) AS Total FROM Customers GROUP BY CustomerName, City;

This query will summarize the number of customers by city. The results will be displayed in a table with columns for CustomerName and City, and a row for the total number of customers in each city.