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 / hemasundar

Answer Posted / hemasundar

Distinct:Its gives only the non duplicate values in a database table.
Unique:The UNIQUE constraint uniquely identifies each record in a database table.its similar to primary key.these values
cannot be repeated.But, nearly both are same...

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is recursive join in sql?

1067

How do sql databases work?

1045

What is sql used for?

1164

Can we call a function containing dml statements in a select query?

1024

What are the advantages of sql? Explain

1153

Can a trigger call a stored procedure?

1127

What is sql performance tuning?

979

Define concurrency control. : Transact sql

1236

List out the acid properties and explain?

1018

how can we find the number of rows in a table using mysql? : Sql dba

1124

How do I run a program in pl sql?

1054

Is a view faster than a stored procedure?

1010

what are myisam tables? : Sql dba

1077

How can you know that statistics should be updated?

1128

What are pl sql data types?

1056