CODEWITHSUNDEEP
ms-accesscompareuniquems-access-2016
VEXEL
VEXEL

Reputation: 1

unique values from two columns ma access - unique values from second column

I have 2 columns in Microsoft Access table and now i need to compare and find a list of unique values from this two columns How can i do it ? get only unique values from second column please help Thank You Image here

Everything I could do, but it didn't work

Upvotes: 0

Views: 58

Answers (1)

Gustav
Gustav

Reputation: 55806

As to your sample, you can simply do:

Select [Column B] From YourTable
Where [Column A] Is Null

or:

Select [Column B] From YourTable
Where [Column B] > 
    (Select Max(T.[Column A]) From YourTable As T)

Upvotes: 1

Related Questions