mySQL 返回每个字段的特定行

Question

我将尽力解释这一点……我希望为每个字段返回 5 个随机行。例如，我有:

SELECT "Name","Ticket ID","Channel"
FROM Tickets
  WHERE "Ticket Created at" between date('2017-09-01') AND date('2017-10-01')
  AND "Channel" = 'Phone' or 'Chat' or 'Email'
  AND "First Agent Primary Email" = 'abc.def@mail.com'

我想要做的是让表格为每个电话 channel 、每个聊天 channel 或每个电子邮件 channel 返回 5 个随机工单 ID。

有人能帮忙吗？

Answer 1

试试这个查询。

SELECT Name,Ticket ID,Channel FROM Tickets
WHERE Ticket Created at between date('2017-09-01') 
AND date('2017-10 
01')
AND Channel IN ( 'Phone', 'Chat' , 'Email')
AND First Agent Primary Email = 'abc.def@mail.com'
ORDER BY  RAND() LIMIT 5;