Read and display no repeated record in the database

zhaozj2021-02-16  82

IDDEPARTMENTCLASSCLASSNOISUSE14 Economic Management Department 15 Computer Sciences 23 Electromechanical Engineering Department 26 Basics 30 Electrical Information Engineering System 31 Electrical Information Engineering Pharmaceutical Electrification 980125-1

There is such a table, there are two electrical information engineering systems in the department, but I only want to display an electrical information engineering department (that is, only the display) uses Select Distinct (Department), CONN 1, 1 implementation, that is, only one record in the repeated record is implemented with the Select Distinct field name from the SELECT DISTINCT field name from the origin name, but there is no problem, and the reading record is the first or the last one or Random read? I haven't figured it out :(

If Which master understands, please spend 1 minute to point out

转载请注明原文地址:https://www.9cbs.com/read-12514.html

New Post(0)