Home » RDBMS Server » Server Administration » Difference between distinct and unique?
Difference between distinct and unique? [message #374538] Mon, 18 June 2001 09:20 Go to next message
neil
Messages: 15
Registered: June 2001
Junior Member
What is the difference between "select unique column_name from table_name..."
and "select distinct column_name from table_name..."?

If there is no resulting difference, are they processed differently by the
RDBMS? If so, which is more efficient?

Report message to a moderator

Re: Difference between distinct and unique? [message #374541 is a reply to message #374538] Mon, 18 June 2001 10:02 Go to previous messageGo to next message
sverch
Messages: 582
Registered: December 2000
Senior Member
As far as I know there is no difference.

Report message to a moderator

Re: Difference between distinct and unique? [message #374552 is a reply to message #374541] Mon, 18 June 2001 11:17 Go to previous message
Andrew again...
Messages: 270
Registered: July 2000
Senior Member
As far as I know, Distinct was Oracle's chosen keyword. Unique is the standards compliant keyword in SQL92 or ANSI or whatever.

Report message to a moderator

Previous Topic: SQL QUERY - HELP REQUIRED
Next Topic: Re: Oracle8i: Add New Column to Bet. Columns
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jul 06 17:32:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.