SELECT DISTINCT or GROUP_CONCAT on table and show multiple fields

Hi There,

is there a way to show only unique records in a table based on two field instead of one.

i tried

SELECT DISTINCT field1, field2 works only for on field
SELECT field1GROUP_CONCAT(field2)

can’t get i right.

so in the table each record has two unique fields, based on this fields i only want to choose one of those records. (don’t display the same records, only one unique one)

Hi,
try

SELECT field1, GROUP_CONCAT(field2)
FROM table
group by field1

🚀 Scriptcase 9.12 is now available! Check out the new features here 👉🚀 Next Monday (02/24), Scriptcase 9.12 will be released! Check out the new features before anyone else 👉