thinkphp如何过滤名字重复的记录?

2025-02-27 23:24:22
推荐回答(3个)
回答1:

example.对字段进行去重

$index = $select->distinct ( true )->where ( 'parent_id=0' )->field ( 'index' )->select ();

SELECT TOP 3
degree ,
COUNT(1) AS 人数
FROM
Student
GROUP BY
degree
ORDER BY
degree DESC

回答2:

example.对字段进行去重

$index = $select->distinct ( true )->where ( 'parent_id=0' )->field ( 'index' )->select ();

回答3:

数据库字段唯一约束吧