Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Differences between UNIQUE and DISTINCT in select statements

Question Posted / pravin d. survase

Answer Posted / pravin d. survase

UNIQUE is only used in oracle but,
DISTINCT is used in all RDBMS.

UNIQUE is used in SELECT statement and as KEY also.
DISTINCT is only used in SELECT.
DISTINCT KEY concept is not present in SQL/ORACLE.

UNIQUE also supress the duplicates but, UNIQUE KEY will
allow the duplicates.
DISTINCT supress the duplicates.

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we use procedures in sql?

1089

Explian rowid, rownum?

1018

how does a local variable is defined using t-sql? : Transact sql

1021

What is difference between pls_integer and integer?

968

Who developed sql?

1052

Explain what is sql?

1119

What is a sql instance vs database?

1120

How to pipe multiline string to isql?

1008

Can there be more than one function with a similar name in a pl/sql block?

986

What is form and report?

993

Is sql considered coding?

1050

What is an inner join sql?

1034

What are secondary keys?

972

Which are the different case manipulation functions in sql?

1028

how do you tune the slow running queries in oracle db , explain the methodology

2814