UNIQUE vs DISTINCT

Database
Enthusiast

UNIQUE vs DISTINCT

Hi,
Could anybody explain me the difference between UNIQUE and DICTINCT keywords?

Exists any command to detect a index definition on table?

Tags (1)
1 REPLY
Enthusiast

Re: UNIQUE vs DISTINCT

Here you go: http://carlosal.wordpress.com/2009/06/02/distinct-vs-group-by-en-teradata/