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 / vijay mohan reddy

Hi Howard Cheon,
you are currect... but we cant able to use
both DISTINCT and UNIQUE, if the select_list contains LOB,
LONG columns. It may not a difference.

Could anyone plz give some another major difference..

Thanks in Advance

Vijay Reddy.

Is This Answer Correct ?    9 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the methods of filing?

935


What is pl sql package?

1039


what is the difference between nested subquery and correlated subquery?

1059


What is pl/sql table? Why is it used?

1051


What packages are available to pl/sql developers?

1068


How would you reference column values before and after you have inserted and deleted triggers?

1068


How do you update f as m and m as f from the below table testtable?

1860


Mention what are different methods to trace the pl/sql code?

1217


What are the types of join and explain each?

1054


Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

1033


How do I view a table in sql?

1013


What is the use of nvl function?

1202


What is rtm in testing?

1121


What is the unique index?

1058


what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1042