Joe,
Use the Order by Clause to set your ordering. Group by will, by design,
eliminate duplicates. GROUP BY is used for aggregate functions, such as
sum(), count() etc.
On 03/29/18 11:00 PM, Joe Yoder wrote:
I have an SQL select statement that includes a group by clause to order the
output for reporting. ...
SELECT account, date, memo, paid_amoun;
FROM QB;
GROUP BY account, date, memo, paid_amoun;
INTO CURSOR det
I happened to discover that the output of the select statement does not
include duplicate records. Is this expected behavior? If so , how should
one group data with duplicate records?
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
