Is there a way to get select and update statements show to rows ids in temporary sorted order For example: SELECT * FROM Persons ORDER BY LastName DESC
P_Id LastName FirstName Address City 2 Svendson Tove Borgvn 23 Sandnes 3 Pettersen Kari Storgt 20 Stavanger 4 Nilsen Tom Vingvn 23 Stavanger 1 Hansen Ola Timoteivn 10 Sandnes Ideally it would work like: Tempid LastName FirstName Address City 1 Svendson Tove Borgvn 23 Sandnes 2 Pettersen Kari Storgt 20 Stavanger 3 Nilsen Tom Vingvn 23 Stavanger 4 Hansen Ola Timoteivn 10 Sandnes Is there a way of creating this somehow? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users