# MYSQL group by and order by query

**URL:** <https://www.ruby-forum.com/t/mysql-group-by-and-order-by-query/150626>\
**Category:** Rails\
**Created:** [October 10, 2008, 3:58pm UTC](https://www.ruby-forum.com/t/mysql-group-by-and-order-by-query/150626 "2008-10-10T15:58:16Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Abhishek\_shukla](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/7cd45c/32.png) [@Abhishek\_shukla](https://www.ruby-forum.com/u/Abhishek_shukla)\
**Post date:** [October 10, 2008, 3:58pm UTC](https://www.ruby-forum.com/t/mysql-group-by-and-order-by-query/150626/1 "2008-10-10T15:58:16Z")

</div>

Hello friends,  
i need to get the latest record of same field  
for e.g

there is a table called xyz and it contains the following field item\_id,  
created\_at

so i want a single record for every similar item\_id whose created\_at is  
the  
latest.

i tried group by with order by but no success, Please help me with  
proper  
query.

Thanks  
Abhi

---

<div class="post-metadata">

**Author:** ![Abhishek\_shukla](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/7cd45c/32.png) [@Abhishek\_shukla](https://www.ruby-forum.com/u/Abhishek_shukla)\
**Post date:** [October 10, 2008, 4:43pm UTC](https://www.ruby-forum.com/t/mysql-group-by-and-order-by-query/150626/2 "2008-10-10T16:43:33Z")

</div>

On Oct 10, 9:57 pm, “Abhishek shukla” [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> i tried group by with order by but no success, Please help me with proper  
> query.
> 
> Thanks  
> Abhi

Xyz.maximum(:created\_at, :group =\> :item\_id)