<div>
SELECT invNO, MAX(CASE WHEN Dflagcount = 1 THEN rowID END) AS rowID<br />
FROM table_name<br />
GROUP BY invNO<br />
HAVING SUM(CASE WHEN Dflagcount = 1 THEN 1 ELSE 0 END) = 1
</div>


SELECT invNO, MAX(CASE WHEN Dflagcount = 1 THEN rowID END) AS rowID
FROM table_name
GROUP BY invNO
HAVING SUM(CASE WHEN Dflagcount = 1 THEN 1 ELSE 0 END) = 1

<div>
That's works great. However, can you talke about:<br />
<br />
<br />
&nbsp;SUM(CASE WHEN Dflagcount = 1 THEN 1 ELSE 0 END) = 1 <br />
<br />
I understand the having is used to filter data returned by Group Bys but not clear on the Case logic...especially the =1 outsited the ()
</div>


That's works great. However, can you talke about:


 SUM(CASE WHEN Dflagcount = 1 THEN 1 ELSE 0 END) = 1

I understand the having is used to filter data returned by Group Bys but not clear on the Case logic...especially the =1 outsited the ()

<div>
Perfect.<br />
Excellent explanation.<br />
<br />
This worked great!
</div>


Perfect.
Excellent explanation.

This worked great!

<div>
This works great!<br />
Thanks again.
</div>


<div>
<div class="content wysiwyg-content">
Thank you all in advance. I suspect this will be an easy one.<br />
<br />
we have:<br />
<br />
invNO &nbsp;rowID &nbsp;DFlagcount<br />
100 &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1<br />
100 &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; null<br />
100 &nbsp; &nbsp; &nbsp; 3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1<br />
101 &nbsp; &nbsp; &nbsp; 4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Null<br />
101 &nbsp; &nbsp; &nbsp; 5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Null<br />
101 &nbsp; &nbsp; &nbsp; 6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1<br />
101 &nbsp; &nbsp; &nbsp; 7 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;null<br />
<br />
We have 2 invoices. &nbsp;We want to pull back in our result set only the row id that corresponds to the invoice that has a Dflagcount =1.<br />
<br />
In this case, invoice 101 RowID 6.<br />
<br />
Thank you in advance!<br />
<br />
-vn
</div>
</div>


Thank you all in advance. I suspect this will be an easy one.

we have:

invNO  rowID  DFlagcount
100       1                1
100       2             null
100       3                1
101       4            Null
101       5            Null
101       6                 1
101       7            null

We have 2 invoices.  We want to pull back in our result set only the row id that corresponds to the invoice that has a Dflagcount =1.

In this case, invoice 101 RowID 6.

Thank you in advance!

-vn

Help with a Group By Query

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.