Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 127605 Views
- ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / cutepa1
Yeah Manoj, Thatz ok, UNIQUE as a constraint. But I like to
know about the diff while its usage in select statement. For
me it seems very similar to DISTINCT, can anyone give me if
there is any difference, please.
| Is This Answer Correct ? | 15 Yes | 15 No |
Post New Answer View All Answers
Write a sql select query that only returns each name only once from a table?
What is thread join () in threading?
what are string data types? : Sql dba
Explain what is sql?
Does truncate free space?
What is %type in pl sql?
What's the procedure?
Is sql port 1433 encrypted?
Is null operator in sql?
How to set up sql*plus output format in oracle?
What does the sign mean in sql?
Why do we use triggers?
What are few of the schema objects that are created using PL/SQL?
what is a primary key? : Sql dba
Which is faster subquery or join?
