从数据库中选择uniq记录 [英] select uniq records from database

问题描述

我在sql中创建了一个表.表的名称是用户.
其中包含以下字段和数据
名称城市州

pooja barmer rajasthan
里图·巴默·拉贾斯坦
pooja barmer rajasthan
里图·巴默·拉贾斯坦

我想要结果

名称城市州
pooja barmer rajasthan
里图·巴默·拉贾斯坦


仅显示uniq记录.如果两个或两个以上记录相同，则仅选择1个记录.

请给我查询它的SQL ?????????

i have make a table in sql. name of table is user.
which contain following field and data
name city state

pooja barmer rajasthan
ritu barmer rajasthan
pooja barmer rajasthan
ritu barmer rajasthan

i want result

name city state
pooja barmer rajasthan
ritu barmer rajasthan


that iwant to display only uniq record.if two or more records are same than select only 1 records.

please give me sql query for it?????????

推荐答案

SELECT DISTINCT name, city, state FROM tbl

或

OR

SELECT name, city, state FROM tbl GROUP BY name, city, state

这篇关于从数据库中选择uniq记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！