Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 135709 Views
- ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / manoj
UNIQUE(Constraint):- Can be only once for a column in a
table
DISTINCT(Clause):- Useed in select query to retrive distinct
(non repeated) data from table(s)
| Is This Answer Correct ? | 114 Yes | 68 No |
Post New Answer View All Answers
What is dml and ddl?
What are the different ways to optimize a sql query?
How do I edit a stored procedure?
define data blocks ? : Sql dba
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
How many sectors are in a partition?
What is a natural join?
What is partition by in sql?
What is a schema sql?
What are properties of the transaction?
How do you write a subquery?
What is a boolean in sql?
describe transaction-safe table types in mysql : sql dba
Explain the components of sql?
Explain two easy sql optimizations.
