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 / satish parashar

After applying the unique clause all the value of column
will be sorted, But in distinct clause it only remove the
duplicacy from the table,not sorted the column value.

Is This Answer Correct ?    6 Yes 15 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are data types in pl sql?

1075


what is the difference between inner and outer join? Explain with example. : Sql dba

971


How do you declare a constant?

909


What is pl sql block structure?

974


Can we join tables without foreign key?

908


how to use in conditions? : Sql dba

958


Does pdo prevent sql injection?

884


What is the difference between microsoft sql and mysql?

920


Is primary key always clustered index?

945


Is foreign key mandatory?

938


what are date and time intervals? : Sql dba

998


What are schema-level triggers?

1045


What found sql?

894


What's the difference between inner join and left join?

947


What are stored procedures in mysql?

967