SQL中IN，LIMIT，唯一

---

Client.where(orders_count: [1,3,5])
SELECT * FROM clients WHERE (clients.orders_count IN (1,3,5));

---

Client.limit(5)
SELECT * FROM clients LIMIT 5;

---

Client.limit(5).offset(30)
这时会从第 31 个记录开始，返回最多 5 个客户对象。生成的 SQL 语句如下：
SELECT * FROM clients LIMIT 5 OFFSET 30

---

distinct 过滤数据字符中重复的数据
select distinct(id) from tablename;

---

查询users表中最后一条记录

select * from users  group by id desc limit 1;