Hello I'm learning SQL recently and I'm struggled with this pb for hours:
for each different value of column A, I want to get first result of column B
did someone know how to do this?

Here's an example

and here's the result I want to have

CodePudding user response：

You may use the MIN function to achieve your desired results. Eg

SELECT
    person,
    account,
    MIN(profile_pic) as profile_pic
FROM
   your_table
GROUP BY
   person,
   account

Let me know if this works for you.