如何从mysql表中获取不同的记录? [英] How to get distinct record from mysql table?

问题描述

我有一个这样的表学生

id | name | zip 
1  | abc  | 1234
2  | xyz  | 4321
3  | asd  | 1234

我想获取所有记录，但不应重复邮政编码.因此，在上述表记录的情况下，应获取记录1和2.第3条记录将不会被提取，因为它的邮政编码已经在第1条记录中

I want to get all records but zip code should not be repeated. So In case of above table records, record No 1 and 2 should be fetched. Record No. 3 will not be fetched because it has a zip code which is already in record No. 1

推荐答案

SELECT DISTINCT fieldName FROM tableName;

以下查询将仅选择不同的"zip"字段.

The following query will only select distinct 'zip' field.

SELECT DISTINCT zip FROM student;

---

SELECT * FROM tableName GROUP BY fieldName;

以下查询将选择所有字段以及不同的zip字段.

The following query will select all fields along with distinct zip field.

SELECT * FROM student GROUP BY zip;

这篇关于如何从mysql表中获取不同的记录?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！