Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 135524 Views
- ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / narendrasai
UNIQUE: it is a constraint and it was created at the time of table creation, where as
DISTINCT: it is a word used at the time of selection.
So both are same, but usage of both the words are different
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are sql functions? Describe the different types of sql functions?
How much ram can sql express use?
Can you selectively load only those records that you need? : aql loader
What is composite data type in pl sql?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
What is sqlerrm?
how to get a list of columns in an existing table? : Sql dba
what are the authentication modes in sql server? How can it be changed? : Sql dba
What is scope of pl sql developer in future?
How do you use collections in procedure to return the resultset?
what is the difference between blob and text? : Sql dba
What is mutating error in pl sql?
What is a string data type in sql?
Does postgresql run on the cloud?
What are the different datatypes available in PL/SQL?
