python - How to select multiple fields in postgresql and only deduplicate one of the fields

Question

select distinct name, age returns columns with different names and ages. If you want to get a result like
lily 23
peter 23, solve it

Answer 1

我猜
select distinct name，age from database.tables where age=23