Hi I have a requirement as to get the last record of a database table whose primary key is an identity field. I would appreciate if anyone can help me out in providing the EJB-QL query so that i can write a suitable finder method. Thanks. Kishore [ October 14, 2005: Message edited by: Kishore Chintalpati ]