Solved

Select statement not working when MAX function is used.

Posted on 2013-11-22
1
334 Views
Last Modified: 2013-11-22
I get the following error when I execute the SELECT statement seen below...

You tried to execute a query that does not inclue the specified expression 'questioncode' as part of an aggregate function.

SELECT questioncode, MAX(regulatoryanswer), inpracticeresponse from vmasterdata where questioncode = 'GQ-005' and regulatoryanswer like "*Day*" or regulatoryanswer like "*Month*"

I am trying to get the largest value in the regulatory column.

This statement works fine without the MAX.

Could somebody help with this and tell me what I am doing wrong?

Thanks.
0
Comment
Question by:tesla764
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 39669635
try this


SELECT questioncode, MAX(regulatoryanswer), inpracticeresponse from vmasterdata where questioncode = 'GQ-005' and regulatoryanswer like "*Day*" or regulatoryanswer like "*Month*"
group by questioncode, inpracticeresponse
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Suggested Courses

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question