Hi, Lets assume a table having following data
No. Name Address ======================== 1 A addrA 2 B addrB 3 C addrC 4 B addrB1 I want to update the filed 'Address' based on field 'Name'. But if there are multiple table entries (The case of B), I just want to update the last entry in the table. How can I write a query for this? My present query is update mytab set Address="addr" where name="B" The output of this query would be No. Name Address ======================== 1 A addrA 2 B addr 3 C addrC 4 B addr But the Output we want is No. Name Address ======================== 1 A addrA 2 B addrB 3 C addrC 4 B addr If my question is not clear, I am ready to explain it more... Thanks, Lloyd ______________________________________ Scanned and protected by Email scanner _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users