Wednesday, March 3, 2010

UNIQUE vs. DISTINCT - Database Design

UNIQUE vs. DISTINCT - Database Design

In SQL:

UNIQUE: constrain on value in specific column.

DISTINCT: retrieve one instance for each possible value.

0 comments: