Re: Unexpected results from a group by clause

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