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...

Differences between UNIQUE and DISTINCT in select statements

Answer Posted / carol

unique is a constraint on coloumnsbut distinct is used in DML for query retrieval in select

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

1005


What is data type in sql?

950


What programs use sql?

994


How does sql developer connect to oracle database?

994


What is the main reason behind using an index?

1012


Why we use cross join?

948


how to return query output in html format? : Sql dba

1070


What problem one might face while writing log information to a data-base table in pl/sql?

1153


Can %notfound return null after a fetch?

1051


What is sql*plus?

1068


Can a select statement fire a trigger?

1152


What are the types of sql commands?

1094


What are the advantages of indexing?

980


What is compiled query?

1030


What is the difference between an inner and outer join?

1008