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 is the difference between nested subquery and correlated subquery?

1053


What is numeric function sql?

1058


How many tables can you join in sql?

957


What is sql*plus?

1075


What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

1000


GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3046


how to convert character strings to numeric values? : Sql dba

1106


what is a composite key ? : Sql dba

1059


what are the differences between char and nchar? : Sql dba

1113


Does sqlite need a server?

1047


Can one improve the performance of sql*loader? : aql loader

1046


What are the different operators available in sql?

1000


What does varchar include?

947


What is clustered index sql?

984


Can a procedure in a package be overloaded?

1043