Note ORDER BY isn't supported in SELECT / INTO or CREATE TABLE AS SELECT (CTAS) statements in [!INCLUDE ssazuresynapse-md] or [!INCLUDE ssPDW].

Transact-SQL Syntax Conventions Note ORDER BY is not supported in SELECT/INTO or CREATE TABLE AS SELECT (CTAS) statements in [!INCLUDE ssSDWfull] or [!INCLUDE ssPDW].

I just granted SELECT access to the users for the table in question and built the whole query string in the app.<BR><BR>Thanks for the help, though, everybody.

Learn how to master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier.

This SELECT statement uses the PROC SQL view SLIB.BADORDR to display joined ORACLE and SAS data in ascending order by the CUSTNUM column and then by the PRODUCT (that is, FIBERNAM) column. The data is ...

What I'd like to do is select 50 rows at a time and paginate the data, and display it in alphabetical order by last name.