Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 228
  • Last Modified:

using distinct and max in access

folks

what do i use to check the distinct records in access

i have data

object      rank
house      1
house      2
car      2
car      4
car      6
cat      1

and want to show the distinct groups and its max rank like so
object      rank
house      2
car      4
cat      1

r
0
rutgermons
Asked:
rutgermons
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
select object, max(rank)
from yourtable
group by object
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now