Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

difference between unique and distinct

Status
Not open for further replies.
raji96

raji96

Programmer
Joined
Aug 7, 2001
Messages
64
Location
US
I know what unique and distinct does both are same,is there any difference between them?

--thanks.
 
Sort by date Sort by votes
If you are talking about using the terms in a SELECT statement, then the two keywords are exactly the same.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

J
  • Locked
  • Question Question
Oracle iCare Gift & Loyalty Portlet - Setup and configurations.
Replies
0
Views
300
jandresHDS
J
Livia8
  • Locked
  • Question Question
Question re: SELECT DISTINCT
Replies
6
Views
1K
SkipVought
S
kernal
  • Locked
  • Question Question
Extract after and between spaces in a string
Replies
1
Views
317
johnherman
johnherman
kernal
  • Locked
  • Question Question
If Day of the Week='Y' (i.e. Mon='Y') and between a Start Date and End Date then Count #of Days
Replies
1
Views
370
Beilstwh
Beilstwh
EM1107
  • Locked
  • Question Question
How to convert CLOB data into number and compare it to other table.
Replies
4
Views
1K
carp
carp

Part and Inventory Search

Sponsor

Back
Top