>I have a table with hundreds of records, which can be divided into three groups. What I am going to do is to select the last 50 records for a group, let's say group A,from this table. Is it possible to issue a SQL command and let the thing done? Thanks!

Pls chk the sql article in KB section, some kind of similar trick was given there