You are a database developer for a company that conducts telephone surveys of consumer music preferences. As the survey responses are received from the survey participants, they are inserted into a table named SurveyData. After all of the responses to a survey are received, summaries of the results are produced. You have been asked to create a summary by sampling every fifth row of responses for a survey. You need to produce the summary as quickly as possible. What should you do

217.

You are a database developer for a company that conducts telephone surveys of consumer music preferences.
As the survey responses are received from the survey participants, they are inserted into a table named SurveyData.
After all of the responses to a survey are received, summaries of the results are produced.
You have been asked to create a summary by sampling every fifth row of responses for a survey.
You need to produce the summary as quickly as possible.

What should you do

Use a cursor to retrieve all of the data for the survey.
Use FETCH RELATIVE 5 statement to select the summary data from the cursor.

Use a SELECT INTO statement to retrieve the data for the survey into a temporary table.
Use a SELECT TOP 1 statement to retrieve the first row from the temporary table.

Set the query rowcount to five. Use a SELECT statement to retrieve and summarize the survey data.

Use a SELECT TOP 5 statement to retrieve and summarize the survey data.

View Description

No description found.