Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

DYNCOL Select Order By Problem

DYNCOL

If you want to have ORDER BY in the query for DYNCOL, you must include the columns you want to order by in the select statement.

Following statement will not work:

select custgroup from table order by custgroup, unit

You must include 'unit' in the select for this to work:

select custgroup, unit from table order by custgroup, unit
Published:

DYNCOL Select Order By Problem

DYNCOL

If you want to have ORDER BY in the query for DYNCOL, you must include the columns you want to order by in the select statement.

Following statement will not work:

select custgroup from table order by custgroup, unit

You must include 'unit' in the select for this to work:

select custgroup, unit from table order by custgroup, unit
For an optimal Community experience, Please view on Desktop
Powered by Zendesk