This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 51%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
I am trying to use command string "ALTER TABLE PIN_Table ORDER BY PIN ASC" PIN_Table and column PIN exist. I am getting "Syntax error near ORDER" I don't see my problem. Have tried a number of different things and nothing fixes the problem.
Man, I am having trouble with SQLite and it has to be me!! All help appreciated.
Bob Scott
hello @bobscott !
To provid addiotional helpi am posting a solution where we create a New Table from PIN_ASC with ODERED Data:
ALTER TABLE PIN_Table ORDER BY PIN ASC;
Then when running SELECT we have our Order
SELECT * FROM PIN_Table ORDER BY PIN ASC;
I hope this helps!
Kindly mark the answer as Accepted and Upvote in case it helped!
Regards
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
sql does not allow defining an order for a table.
while creating a new table and loading with a sorted sequence, may cause select * from table to return sorted requests, its only a coincidence. another insert or a select with a where clause, or a join may change the order.
you should never assume select * from a table has an order unless you specify an order by clause.
hello @bobscott !
The ORDER BY clause is not supported in the ALTER TABLE statement in SQLite. This means that you cannot use the ORDER BY clause to sort the rows of a table while altering it.
https://www.sqlitetutorial.net/sqlite-group-by/
If you want to sort the rows of the PIN_Table table by the PIN column, you can use the SELECT statement with the ORDER BY clause instead. For example, you can use the following command:
SELECT * FROM PIN_Table ORDER BY PIN ASC;
https://www.tutorialspoint.com/sqlite/sqlite_alter_command.htm
https://www.tutorialspoint.com/sqlite/sqlite_select_query.htm
https://www.tutorialspoint.com/sqlite/sqlite_order_by.htm
https://scaron.info/blog/aggregate-functions-in-sql.html
https://www.guru99.com/sqlite-query.html
Another post that may help is here :
https://www.sqlitetutorial.net/sqlite-alter-table/
I am re creating your issue:
ERROR MESSAGE :
With Select though :
I hope this helps!
The answer or portions of it may have been assisted by AI Source: ChatGPT Subscription which was tested and is displayed above
Kindly mark the answer as Accepted and Upvote in case it helped!
Regards
I am trying to use command string "ALTER TABLE PIN_Table ORDER BY PIN ASC" PIN_Table and column PIN exist. I am getting "Syntax error near ORDER" I don't see my problem.
I do see your problem. There is such syntax in SQL Server. Hm, you mention SQLite, but you have tagged the post SQL Server - those are two quite different product. (If you work with SQLite, you should probably find an SQLite forum somewhere; as SQLite is not a Microsoft product, this is not really the place.
Anyway, I doubt that the syntax you are trying works in SQLite either, because it does not really make any sense. A table in a relational database is by definition an unordered object, you cannot order it. You can add an index to it which imposes a physical ordering, but that's some different from the table definition.