hide row with duplicate field with another row

crije22

Regards,

How can I hide a row that has a duplicate field with another row?

Thanks for all your contributions.

kthorngren

Thats a tough one. If you only want one row form your query you could use something like the sql select distinct statement to retrieve only one record.

However if you would like all the data at the client then I would probably look at using a search plugin:
https://datatables.net/manual/plug-ins/search

I guess it depends on where you want to filter the data and what the criteria is to decide which to display and filter.

Kevin

crije22

@kthorngren thanks

Your response from the distict in sql made me realize that the problem could be solved with a group by

again thanks.