if we are trying to add the several columns in select statement and only one condition in group by.
how can we do that ??
Example:
select ContactTracking.Contact_ID,ContactTracking.HcnID
FROM
ContactTracking ContactTracking
LEFT OUTER JOIN HRA hra ON hra.HcnID = ContactTracking.HcnID
WHERE
ContactTracking.contact_date>'10-jan-2009'
AND ContactTracking.Call_end_time is not null
AND ContactTracking.HcnID NOT IN (Select HcnID FROM TestIDs)
AND Contact_ID in ('122734','122738')
GROUP BY Contact_ID
Member
39 Points
20 Posts
Multiple select with single Group BY
Jun 24, 2010 03:14 AM|uthappa|LINK
Hi,
if we are trying to add the several columns in select statement and only one condition in group by.
how can we do that ??
Example:
select ContactTracking.Contact_ID,ContactTracking.HcnID
FROM
ContactTracking ContactTracking
LEFT OUTER JOIN HRA hra ON hra.HcnID = ContactTracking.HcnID
WHERE
ContactTracking.contact_date>'10-jan-2009'
AND ContactTracking.Call_end_time is not null
AND ContactTracking.HcnID NOT IN (Select HcnID FROM TestIDs)
AND Contact_ID in ('122734','122738')
GROUP BY Contact_ID
sqLl SELECT
Member
330 Points
79 Posts
Re: Multiple select with single Group BY
Jun 24, 2010 01:24 PM|Jester98x|LINK
Group By needs to list no aggregated values, so in your case you can't do it with just one condition.
A helpful article to understand Group By http://weblogs.sqlteam.com/jeffs/jeffs/archive/2007/07/20/60261.aspx
Looking at the query I'm not sure why you would want to use a Group By clause anyway. Can you provide more detail on what you are trying to achieve?