# Last record

**URL:** <https://www.ruby-forum.com/t/last-record/102267>\
**Category:** Rails\
**Created:** [August 14, 2006, 9:53am UTC](https://www.ruby-forum.com/t/last-record/102267 "2006-08-14T09:53:10Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![flnative](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/5daacb/32.png) [@flnative](https://www.ruby-forum.com/u/flnative)\
**Post date:** [August 14, 2006, 9:53am UTC](https://www.ruby-forum.com/t/last-record/102267/1 "2006-08-14T09:53:10Z")

</div>

hi @all

Can anyone help me? I would like to read the last two records from a  
database. In the database I have a table with id, name and sex.

How can I read the last two records from the entered names, who are  
female? There are two conditions I need:

> last entries  
> sex-condition

User.find(:all, :condition…) ??

---

<div class="post-metadata">

**Author:** ![flnative](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/5daacb/32.png) [@flnative](https://www.ruby-forum.com/u/flnative)\
**Post date:** [August 15, 2006, 2:19pm UTC](https://www.ruby-forum.com/t/last-record/102267/2 "2006-08-15T14:19:44Z")

</div>

Well… you could add at created\_at field to the table, then order by  
that  
and retrieve the last two rows.

User.find(:all, :order =\> ‘created\_at desc’, :limit =\> 2)

-Jonathan.

---

<div class="post-metadata">

**Author:** ![flnative](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/5daacb/32.png) [@flnative](https://www.ruby-forum.com/u/flnative)\
**Post date:** [August 15, 2006, 2:19pm UTC](https://www.ruby-forum.com/t/last-record/102267/3 "2006-08-15T14:19:46Z")

</div>

@last\_two\_users = User.find(:all, :conditions =\> “sex-condition =  
‘female’”, :order =\> “created\_at DESC”)

assuming you are storing created\_at time, right? If not, you could  
order by “id DESC”.

That should do it.

---

<div class="post-metadata">

**Author:** ![flnative](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/5daacb/32.png) [@flnative](https://www.ruby-forum.com/u/flnative)\
**Post date:** [August 15, 2006, 2:20pm UTC](https://www.ruby-forum.com/t/last-record/102267/4 "2006-08-15T14:20:24Z")

</div>

M. R. wrote:

> User.find(:all, :condition…) ??  
> How about this (not tested):

count = User.count(:conditions =\> “…”)  
User.find(:all, :conditions =\> “…”, :limit =\> 2, :offset =\> count-2)

–  
Istvan Hoka