Rails 站内信数据表,如何取出某个用户最近 10 个联系人?

imwildcat · October 23, 2014 · Last by imwildcat replied at October 23, 2014 · 1412 hits

我的站内信的数据表大约有如下字段:

  • id
  • receiver_id
  • sender_id
  • is_read
  • content
  • created_at

eg. 如何取出 receiver_id = 1 的最近 10 个 sender_id?

==============================

表述有误,10 个不同的 sender_id

==============================

已经找到: http://guides.rubyonrails.org/active_record_querying.html

query = Client.select(:name).distinct
# => Returns unique names

query.distinct(false)
# => Returns all names, even if there are duplicates

select * from table where receiver_id = 1 order by id desc limit 10

Message.where(receiver: 1).order(id: :desc).limit(10)

#1 楼 @saiga 表述有误,10 个不同的 sender_id

You need to Sign in before reply, if you don't have an account, please Sign up first.