Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 136415 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
how to convert dates to character strings? : Sql dba
How is a PL/SQL code compiled?
What is asqueryable?
What do you mean by table in sql?
how to use 'mysql' to run sql statements? : Sql dba
How do I run a pl sql procedure in sql developer?
Can primary key be changed?
Is and as keyword in pl sql?
What is the advantage of nosql?
Is it possible to create startup or shutdown trigger for on-schema?
Can we use update in sql function?
What are keys in sql?
How do you delete a table?
What are views in sql?
what is the use of set statement in tsql? : Transact sql
