SQL show only one when register has the same values in 2 columns

Asked Aug 30 '17 at 04:08

Active Oct 24 '19 at 11:58

Viewed 159 times

I am using Postgres and have this query:

select d.id,d.santoral_id,d.tipointencion_id from intencion_detalle d
join intencion i ON (i.id=d.intencion_id)
where i.fecha='2017-08-29';

and this is the output:

I want the row 6 and 7 that has the same santoral_id and tipointencion_id to be shown only once not multiple times, and in the same query I want to show the column description that is not in the image but exist in the table. How can I do this?

edited Oct 24 '19 at 11:58

Toby Speight

27,591
48
66
103

asked Aug 30 '17 at 04:08

matQ

2

how about using `group by` query – Muhammad Rahmatullah Aug 30 '17 at 04:10
1

which id you want then? 96 or 97 ?.. – Vao Tsun Aug 30 '17 at 04:30
@matQ: kindly paste your final result along with table schema. – zarruq Aug 30 '17 at 05:16
1

Most people here want formatted text, not images. – jarlh Aug 30 '17 at 06:50
2

Possible duplicate of [Postgresql GROUP\_CONCAT equivalent?](https://stackoverflow.com/questions/2560946/postgresql-group-concat-equivalent) – VBoka Oct 24 '19 at 12:12

SQL show only one when register has the same values in 2 columns

0 Answers0