not duplicate

[yuchieh]

I have tables linked for schools - departments - programs.
One school has various departments; one department provides various programs. I made a query to display schools under each program (sort and group by program).

However, there are a few cases, for example, one school with 3 departments, all 3 departments provide the same programA. Therefore, under programA, the school is listed 3 times.

Because they are unique records (because of 3 department_id), "select distinct" doesn't get rid of duplicate schools under one program. What should I do to have the school listed only once under programA?

Thanks.

 

[jhall156]

you could use the aggregate function MAX() and then group by the rest of your columns. I started out with nothing, and I still have most of it.

 

[yuchieh]

Yes, I use group by and got the results I wanted.

Thanks.