What is the best way to get distinct values from a table?

I am curious what would be the best way to get distinct values from a table. I have

export async function getYearsThatHaveVotes({ division }: { division: string }) {
  const yearsWithVotes = await db
    .select({
      year: sql<number>`DISTINCT ${weeklyFinalRankings.year}`,
    })
    .from(weeklyFinalRankings)
    .where(sql`${weeklyFinalRankings.division} = ${division}`)
    .orderBy(sql`${weeklyFinalRankings.year} DESC`)

  return yearsWithVotes
}

export async function getYearsThatHaveVotes({ division }: { division: string }) {
  const yearsWithVotes = await db
    .select({
      year: sql<number>`DISTINCT ${weeklyFinalRankings.year}`,
    })
    .from(weeklyFinalRankings)
    .where(sql`${weeklyFinalRankings.division} = ${division}`)
    .orderBy(sql`${weeklyFinalRankings.year} DESC`)

  return yearsWithVotes
}

But it just feels weird importing the schema to use it.

2 Replies

Darren•4mo ago

https://orm.drizzle.team/docs/select#distinct

jsingleton37OP•4mo ago

Oh nice! So I can just do

export async function getYearsThatHaveVotes({ division }: { division: string }) {
  const distinctYearsWithVotes = await db
    .selectDistinct({
      year: weeklyFinalRankings.year,
    })
    .from(weeklyFinalRankings)

  return distinctYearsWithVotes
}

export async function getYearsThatHaveVotes({ division }: { division: string }) {
  const distinctYearsWithVotes = await db
    .selectDistinct({
      year: weeklyFinalRankings.year,
    })
    .from(weeklyFinalRankings)

  return distinctYearsWithVotes
}

Gaming

Programming

What is the best way to get distinct values from a table?