# Read last entry from data base

**URL:** <https://www.ruby-forum.com/t/read-last-entry-from-data-base/152132>\
**Category:** Rails\
**Created:** [October 30, 2008, 12:43pm UTC](https://www.ruby-forum.com/t/read-last-entry-from-data-base/152132 "2008-10-30T12:43:33Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![xxmithila](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/x/ebca7d/32.png) [@xxmithila](https://www.ruby-forum.com/u/xxmithila)\
**Post date:** [October 30, 2008, 12:43pm UTC](https://www.ruby-forum.com/t/read-last-entry-from-data-base/152132/1 "2008-10-30T12:43:33Z")

</div>

Hi…

I want to read ID of last entered data set from table, are there any  
possible ways to it?  
help Im stucked…  
thankx

---

<div class="post-metadata">

**Author:** ![xxmithila](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/x/ebca7d/32.png) [@xxmithila](https://www.ruby-forum.com/u/xxmithila)\
**Post date:** [October 30, 2008, 12:45pm UTC](https://www.ruby-forum.com/t/read-last-entry-from-data-base/152132/2 "2008-10-30T12:45:20Z")

</div>

try  
Model.find(:last)

---

<div class="post-metadata">

**Author:** ![xxmithila](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/x/ebca7d/32.png) [@xxmithila](https://www.ruby-forum.com/u/xxmithila)\
**Post date:** [October 30, 2008, 12:48pm UTC](https://www.ruby-forum.com/t/read-last-entry-from-data-base/152132/3 "2008-10-30T12:48:17Z")

</div>

or:

User.find(:all, :order =\> ‘id DESC’, :limit=\>1)

On Oct 30, 12:44 pm, “bala kishore pulicherla” [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

---

<div class="post-metadata">

**Author:** ![xxmithila](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/x/ebca7d/32.png) [@xxmithila](https://www.ruby-forum.com/u/xxmithila)\
**Post date:** [October 30, 2008, 1:26pm UTC](https://www.ruby-forum.com/t/read-last-entry-from-data-base/152132/4 "2008-10-30T13:26:33Z")

</div>

thankx guys  
but  
still there is a problem

User.find(:all, :order =\> ‘id DESC’, :limit=\>1)

and

Model.find(:last)

both return “#” mark only. whats the reson? i want last index id

---

<div class="post-metadata">

**Author:** ![xxmithila](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/x/ebca7d/32.png) [@xxmithila](https://www.ruby-forum.com/u/xxmithila)\
**Post date:** [October 30, 2008, 1:29pm UTC](https://www.ruby-forum.com/t/read-last-entry-from-data-base/152132/5 "2008-10-30T13:29:30Z")

</div>

ok then say

lst\_id = Model.find(:last).id  
puts lst\_id.inspect

hope 'll get this

as Model.find\_last retunrns the entire last record

On Thu, Oct 30, 2008 at 5:53 PM, mithila karunarathna  
\<removed\_email\_address@domain.invalid

---

<div class="post-metadata">

**Author:** ![xxmithila](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/x/ebca7d/32.png) [@xxmithila](https://www.ruby-forum.com/u/xxmithila)\
**Post date:** [October 30, 2008, 1:12pm UTC](https://www.ruby-forum.com/t/read-last-entry-from-data-base/152132/6 "2008-10-30T13:12:26Z")

</div>

If you want only the id of the last entered data then try this,  
User.maximum(‘id’)  
This will return the maximum id which will be anyways the last one.

xxmithila wrote:

> Hi…
> 
> I want to read ID of last entered data set from table, are there any  
> possible ways to it?  
> help Im stucked…  
> thankx

---

<div class="post-metadata">

**Author:** ![xxmithila](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/x/ebca7d/32.png) [@xxmithila](https://www.ruby-forum.com/u/xxmithila)\
**Post date:** [October 30, 2008, 1:30pm UTC](https://www.ruby-forum.com/t/read-last-entry-from-data-base/152132/7 "2008-10-30T13:30:06Z")

</div>

Thankx guys I got the answer…  
WoW…  
answer was

Model.maximum(“id”)

thank u again for ur help