revraz Posted February 6, 2009 Share Posted February 6, 2009 If I have a table like ID | Desc | Sortorder 1 One 3 4 Two 2 6 Three 1 Is there a way I can use a single query to change the Sortorder to 1,2,3 based on my ORDER BY ID without having to write a script? Link to comment https://forums.phpfreaks.com/topic/144007-solved-oracle-reorder-with-just-a-query/ Share on other sites More sharing options...
revraz Posted February 6, 2009 Author Share Posted February 6, 2009 Figured it out Link to comment https://forums.phpfreaks.com/topic/144007-solved-oracle-reorder-with-just-a-query/#findComment-755961 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.