Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. petschek

    mysql percentage question

    HTH, Thanks, but that doesn't give me % per location. It gives me % for the whole. In reference to my initial output in my post, I'm looking for percentages for CAM and for BOS, separately. Thanks!
  2. petschek

    mysql percentage question

    I'm working with survey data. Essentially, I want to count total responses for a question for a location, then use that total to create what percentage of all responses each particular response is, for it's particular location. I then want to group results by location. An ideal output would be...
  3. petschek

    Aggregate 'count' with GROUP BY

    thanks.
  4. petschek

    Aggregate 'count' with GROUP BY

    Thanks, however, I'm using MySQL, and can't get the right syntax for the OVER() or WITH clauses.
  5. petschek

    Aggregate 'count' with GROUP BY

    I'm working with survey data. Essentially, I want to count total records for a location, then use that total to create what percentage of all records each response is. I then want to group results by location. An ideal output would be similar to this: Question1 | State | City | % yes |...

Part and Inventory Search

Back
Top