How sort result in group

table
a - 1 , a - 2 , a -3
b -1 , b - 2
c - 2 , c -5

I want to group and min value
a - 1
b - 1
c - 2

Plase help

Hello @jeong

Welcome to the community!
What is it?

table
a - 1 , a - 2 , a -3
b -1 , b - 2
c - 2 , c -5

Regards

Hello @viktor.liablin
For example
1) Suppose there is a review table in the company that leaves a brief work report note.
2)There are employees of A, B, and C, and each employee writes a report memo about their work.
3) The review table consists of employee, memo, and date columns.

4) Row is stacked as follows.

  1. (A, Work started, 2022.05.01)
  2. (A, Working, 2022.05.02)
  3. (B, Implementation failed, 2022.05.02)
  4. (B, Work completed, 2022.05.05)
  5. (C, On Vacation, 2022.05.03)
  6. (C, Start of business, 2022.05.12)

5) I want to check the last memo for each employee.
ex)

  1. (A, Working, 2022.05.02)
  2. (B, Work completed, 2022.05.05)
  3. (C, Start of business, 2022.05.12)

Hello @jeong!

To do this, you need to take the values from the database and sort them by date.
Our video tutorials can help you with this:
First Steps - Developing a Basic App with Database Integration
Database Integration - Saving data in the database
How to fetch sorted data from the Backendless database

Regards,
Alexander