MS Access: How to compare and filter data in a column-CodePudding

I am a new user and here is my first question,

I have newly started working on MS access and I am having problems to filter maximum of a column data but according to the data in an another column as well.

Let me explain the situation with a test data: Table consists of Column A, is a short text, and column B is an integer,

In the SQL Tab (not shown but bottom right of the query designer)

SELECT Test.ColumnA, Last(Test.ColumnB) AS ColumnB
FROM Test
GROUP BY Test.ColumnA;

| ColumnA | ColumnB |

| AA | 2 |

| BB | 4 |