In the SQL Query, you can specify a 'GROUP BY' clause. What TIBCO Product are you asking this about
But this query, below, is illegal now in the current versions of MySql. The 2nd select expression, f.price, is a non-aggregate. which price
SELECT f.name, f.price
FROM fruit_table f
GROUP BY f.name
Each expression needs to either be referenced in the GROUP BY clause, or used in an aggregate function, as below:
SELECT f.name, SUM(f.price)
FROM fruit_table f
GROUP BY f.name
MySQL 8.0 Reference Manual
Aggregate Function Descriptions
MySQL Handling of GROUP BY