oracle - Difference between SELECT DISTINCT and SELECT UNIQUE -


possible duplicate:
unique vs distinct multi-column in oracle 9i

proper difference between select distinct , select unique points , examples.

select distinct , select unique behave same way in oracle.

while distinct ansi sql standard, unique oracle specific statement.

look here: http://psoug.org/definition/distinct.htm


Comments

Popular posts from this blog

javascript - Iterate over array and calculate average values of array-parts -

iphone - Using nested NSDictionary with Picker -

objective c - Newbie question -multiple parameters -