Probably last inserted record. If you do SELECT * FROM stud_infos then the natural order is returned. The last record in your result set will be the one you need. Since you have no information about a PK field, there is no way to limit or reverse the query so it just returns your required record.
last record means, i just want to bring the record pointer to the end of file so that i can extract the record that is last inserted...the problem is the last record is unknown...(i want to perform an sql command the is similar to the .movelast command in visual basic)...simply moving the record pointer the last record in the table...
ex...my primary key is stud_id...
records in the table stud_infos
The last record here is MCC-11-12-0007 but the scenario is i dont have idea whatever is the value of this last record since the last record will change if their are new insertion or deletion of records. this MCC-11-12-0007 is the last record...so i have to bring the record pointer this record so that i can extract the stud_id MCC-11-12-0007.... thanks a lot..po.:)
ok ill try to insert the time and the date of insertion of the record...thanks...im not using autoincrement...or autogenration of id no....but thanks...i can use it in some of my modules..:)...i ll just post any update of my work thanks...