Geeks Talk

Prepare for your Next Interview




difference between unique and distinct

This is a discussion on difference between unique and distinct within the Oracle forums, part of the Databases category; hey.. Both r remove duplicats.. thn. what is a difffernce between unique and distinct.....


Go Back   Geeks Talk > Databases > Oracle

difference between unique and distinct difference between unique and distinct

Register FAQ Members List Calendar Mark Forums Read

Reply

 

Thread Tools Display Modes
  #1 (permalink)  
Old 08-04-2008
Junior Member
  
Join Date: Apr 2008
Location: ahmedabad
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
arpitace is on a distinguished road
difference between unique and distinct
hey..
Both r remove duplicats..
thn.
what is a difffernce between unique and distinct..
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 08-05-2008
Moderator
  
Join Date: Jun 2007
Location: Bangalore,India
Posts: 1,432
Thanks: 8
Thanked 125 Times in 112 Posts
debasisdas will become famous soon enoughdebasisdas will become famous soon enough
Re: difference between unique and distinct
Both can be used in place of each other alternately.
Reply With Quote
  #3 (permalink)  
Old 08-12-2008
Junior Member
  
Join Date: Jul 2008
Location: chennai
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
vantagepoint is on a distinguished road
Smile Re: difference between unique and distinct
Quote:
Originally Posted by arpitace View Post
hey..
Both r remove duplicats..
thn.
what is a difffernce between unique and distinct..
UNIQUE constraints are typically enforced using a UNIQUE index. However, in a data warehouse whose tables can be extremely large, creating a unique index can be costly both in processing time and in disk space. a unique constraint doesn't allow duplicate values in a column. where as distinct Eliminating duplication in the result set
Reply With Quote
Reply

  Geeks Talk > Databases > Oracle

« Want to be DBA | ..Oracle UserName n Password »

Thread Tools
Display Modes
Linear Mode Linear Mode


Similar Threads

Thread Thread Starter Forum Replies Last Post
what is unique key priyasp_msit SQL Server 3 04-22-2008 05:45 AM
Distinct keyword in Oracle SQL ily_saravanan SQL 1 03-29-2008 12:45 AM
Load Distinct and Duplicate values to different targets tanya123 Data Warehousing 1 02-25-2008 09:06 PM
Alternative for SELECT DISTINCT to query 2 million records Geek_Guest SQL 1 08-06-2007 09:29 AM
difference bet unique and distinct smitai Oracle Certification 2 06-18-2007 04:00 AM


All times are GMT -4. The time now is 07:31 PM.

Contact Us - Geeks Discussions - Archive - Privacy Statement - Top

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved