postgresql - 如何从 postgresql 数据库中获取唯一值
问题描述
我有一个表名目标,
id date valueweekmodified goal_type_id user_id
1 2016-01-07 2 1 2016-01-07 16:21:56 3 3
2 2016-01-07 5 1 2016-01-07 16:21:56 1 3
3 2016-01-07 0 1 2016-01-07 17:17:01 3 4
4 2016-01-07 500 1 2016-01-07 17:17:01 1 4
5 2016-01-07 0 1 2016-01-07 17:50:11 3 6
6 2016-01-07 300 1 2016-01-07 17:50:11 1 6
7 2016-01-07 1 1 2016-01-07 17:52:40 3 5
我需要根据以下内容获取不同的值,
id date valueweekmodified goal_type_id user_id
1 2016-01-07 2 1 2016-01-07 16:21:56 3 3
2 2016-01-07 5 1 2016-01-07 16:21:56 1 3
3 2016-01-07 0 1 2016-01-07 17:17:01 3 4
4 2016-01-07 500 1 2016-01-07 17:17:01 1 4
5 2016-01-07 0 1 2016-01-07 17:50:11 3 6
6 2016-01-07 300 1 2016-01-07 17:50:11 1 6
7 2016-01-07 1 1 2016-01-07 17:52:40 3 5
我尝试了以下查询:
select distinct goal_type_id,id ,date,valueweekmodified,user_id from goal;
但我得到了重复。任何人都可以帮助我吗?