ORDER BY and GROUP BY Together

BigMemory Max 4.3.3 | Product Documentation | BigMemory Max Developer Guide | Searching with BigMemory SQL | SQL Syntax and Examples | ORDER BY and GROUP BY Together

ORDER BY and GROUP BY Together

If ORDER BY is used with GROUP BY, the ordering attributes are limited to those listed in the GROUP BY clause.

select age from Person where ((age > 100 and zip = 20144) or time > 10)
group by age order by age ascending
select age, zip from Person where ((age > 100 and zip = 20144) or time > 10)
group by age, zip order by age asc, zip desc

Copyright © 2010 - 2019 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.