Files
wecom_it_smart_desk/archives/tmp_query.sql

6 lines
153 B
SQL

SELECT id, employee_name, status, assigned_agent_id, created_at
FROM conversations
WHERE employee_name LIKE '%宋献%'
ORDER BY created_at DESC
LIMIT 5;