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 gkittelson 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
Aug 7, 2001
64
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

Livia8
  • Locked
  • Question
Question re: SELECT DISTINCT 1
Replies
6
Views
811
SkipVought
S
kernal
  • Locked
  • Question
Extract after and between spaces in a string 1
Replies
1
Views
114
johnherman
johnherman
kernal
  • Locked
  • Question
If Day of the Week='Y' (i.e. Mon='Y') and between a Start Date and End Date then Count #of Days 1
Replies
1
Views
145
Beilstwh
Beilstwh
EM1107
  • Locked
  • Question
How to convert CLOB data into number and compare it to other table.
Replies
4
Views
594
carp
carp
kernal
  • Locked
  • Question
Extract string before the first "-" it finds and the space prior to the "-"
Replies
5
Views
209
carp
carp

Part and Inventory Search

Sponsor

Back
Top