You tried to execute query not part of aggregate function

Question

0.00/5 (No votes)

See more:

C#

SELECT  a.staff,a.logiodate,a.LogInTime,a.LogOutTime,a.nodeid
 FROM (SELECT   NGAC_USERINFO.username AS Staff, Int([Logtime]) AS LogIODate, Format(Min(NGAC_LOG.logtime),"h:m:s") AS LogInTime, Format(Max(NGAC_LOG.logtime),"h:m:s") AS LogOutTime,nodeid 
FROM NGAC_LOG INNER JOIN NGAC_USERINFO ON NGAC_LOG.userid = NGAC_USERINFO.userid WHERE ( NGAC_LOG.nodeid=1 AND ((Int([logtime])) Between  #21/09/2016# And #21/09/2016 23:59:59#)) 
GROUP BY  NGAC_USERINFO.username, NGAC_LOG.Userid, Int([Logtime]), Int([Logtime]), nodeid ) AS A
 INNER JOIN NGAC_TERMINAL ON A.nodeid=NGAC_TERMINAL.nodeid 
group by staff,logiodate,LogInTime,LogOutTime,a.nodeid
having LogInTime>'9:45:00'

What I have tried:

kindly help
thanks in advance

Posted 28-Sep-16 20:36pm

neeraj_

Updated 28-Sep-16 20:59pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Bernhard Hiller · Accepted Answer · 2016-09-28T20:59:00

Solution 1

Your query combines two select queries. Only the inner query uses "aggregate" functions (i.e. Min, Max, Sum, Avg, Count), so only the inner query must have a GROUP BY clause.
The outer query itself does not use any aggregate functions, it only displays the aggregate values calculated by the inner query. Hence it must not have a GROUP BY clause. You can omit it or replace it by an ORDER BY clause.

Posted 28-Sep-16 20:59pm

Bernhard Hiller

Comments

neeraj_ 29-Sep-16 3:08am

thanks sir its done

Maciej Los 29-Sep-16 7:18am

5ed!