> But I need my rowid to be chaged as follows. > > > > Rowid Id Name > > > > 1 4 aaa > > 2 3 bbb > > 3 2 xxx > > 4 1 zzz
If you are looking Rowid to contain serial numbers every time then you can query for only Id and Name and then while extracting the query result you can append your own serial numbers as part of post processing the query result. HTH Bharath On 3/14/08 11:32 AM, "Mahalakshmi.m" <[EMAIL PROTECTED]> wrote: > > > Rowid Id Name > > > > 4 4 aaa > > 3 3 bbb > > 2 2 xxx > > 1 1 zzz > > > > But I need my rowid to be chaged as follows. > > > > Rowid Id Name > > > > 1 4 aaa > > 2 3 bbb > > 3 2 xxx > > 4 1 zzz > > > > I tried with Views but its rowid is not changed. > > > > But by creating one new table like > > "create table Temp as select Name from Mytable order by Name;" > > gives the desired result as above. > > > > Its taking more time for this. > > So I there any other way I can do the same without creating table because in > My table I am having many > > fields and each time I will create and drop the table for each fields. > > > > Can anyone please help to solve this. > > > > Thanks & Regards, > > Mahalakshmi.M ----------------------------------------------- Robosoft Technologies - Come home to Technology Disclaimer: This email may contain confidential material. If you were not an intended recipient, please notify the sender and delete all copies. Emails to and from our network may be logged and monitored. This email and its attachments are scanned for virus by our scanners and are believed to be safe. However, no warranty is given that this email is free of malicious content or virus. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
