0
Follow
0
View

How can I remove duplicate values in the drop-down list

dkzhu120 注册会员
2023-02-28 21:06

Two identical records exist. Using keyword distinct can remove distinct
weight removal based on a single field to accurately remove weight. When
is applied to multiple fields, the weight can be removed only when the fields are identical. The
keyword distinct takes effect only if it is placed in the first SQL statement

SELECT distinct workshop field FROM b_EquipmentInfo"

dzh171 注册会员
2023-02-28 21:06

You can use distinct duplicate field values in a query statement. So there's no repetition.