Update query to get results as count

I have a MS SQL Query on a web page -

SELECT [login to view URL], [login to view URL], QuestionOptions.[option]

FROM SurveyResponse INNER JOIN

QuestionOptions ON [login to view URL] = [login to view URL]

WHERE ([login to view URL] = 11)

SurveyResponse is a table with thousands of users response to questions

QuestionOptions is a table with the available responses to the questions.

I need the query updated so that I get just a count of how many of each option available is in the query - not the full list of all several thousand results. - need to keep the questionid so we only have one question at a time

Keahlian: Microsoft SQL Server, SQL

Lihat lebih lanjut: php script display query results, show query results website, oracle include column headers query results, count number of rows in sql query result php, count number of rows in sql query result c#, count number of rows in sql query result, count number of rows in sql query result oracle, count number of rows in sql query result java, how to get count 0 in sql query, count number of rows in mysql query result, count number of columns in sql query result, gridview displaying search results count, google map mysql query results, extract results count google, php displaying query results, count time continuously mfc, count time project igoogle, create browser game java count time, php count time script browser game, access query count time periods examples date

Tentang Pemberi kerja:
( 426 ulasan ) Davenport, United States

ID Proyek: #18931899

Diberikan kepada:


Hello, As an expert in ms sql server, i am very much interested to fix this query. I can do it quickly and available now to do it. Thanks

$19 USD dalam 0 hari
(210 Ulasan)

6 freelancer menawar dengan rata-rata $22 untuk pekerjaan ini


Hi, I have 9 years experience in development and deployment that includes SQL Server, SSRS, SSIS and .NET. Involved in SQL Server activities like Installing, Migrations, Table Partitioning, Configuring maintenanc Lebih banyak

$25 USD dalam 1 hari
(47 Ulasan)

Please message me. Please review my profile. I have 9.2 years experience in MS SQL Server and 6.4 years experience in SSRS, SSIS (Import / Export). Please let me Lebih banyak

$24 USD dalam 0 hari
(22 Ulasan)

Hi Boss! I will available full time for this project and available until you satisfied with work,As a senior developer who has more than 5 years of experience in .NET Development,i believe my abilities would be perfec Lebih banyak

$25 USD dalam 0 hari
(0 Ulasan)

Hi I would be happy to work with you I have experience in MySQL and other databases I am waiting for your message to help you. thank yo

$15 USD dalam 1 hari
(0 Ulasan)

Hello, How are you? I am strongest SQL expert. I have experience to develop several websites for 4+ years. If you have any issue, I will solve it quickly. Please reply me. Thank you.

$25 USD dalam 1 hari
(0 Ulasan)