Skip to main content
distinct

distinct

1 4.4
A SQL word that shows only different rows
  • adjective
  • /dɪˈstɪŋkt/
  • Specialized
translation icon : DISTINCT
  • The software can filter the results to show only distinct values, eliminating any duplicates from the dataset.

Examples

  • So today I'm going to assume all items have distinct keys.

  • So what you want now is to count how many distinct ways can you choose four items given N total choices.

  • There are lots of internet resources that allow you to examine distinct brand names and designs.

    Blog text (27)
  • Distinct starting points always give you distinct outputs.

  • That means it has to contain all distinct binary N tuples.

  • Matter in our O-region can assume about 10 to the 10^90 distinct states.

    Academic text (2006)
  • Instantaneous review and the ability to delete or re-photograph a subject are another distinct advantage.

    Academic text (2004)
  • Moreover, C++ provides a distinct namespace abstraction.

    Blog text (19)
  • And at the end of those 10 decisions, you would be left with a list of 10 distinct webpages matching your exact search request—10.

    Academic text (2013)
  • In addition, the hopping technology facilitates the use of multiple pairs in close proximity by setting distinct algorithms to preclude mutual interference.

    Academic text (1996)

Antonyms

55 3.2

A copy that is exactly the same as the original

Surface Forms

distinct positive
distincter comparative
distinctest superlative

Etymology

Distinct comes from a Latin idea of 'marking apart', with dis- meaning 'apart', and in SQL the keyword distinct tells the system to keep only items that are separate or unique. So, using distinct removes copies and returns only different rows.