Differences between UNIQUE and DISTINCT in select statements
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
what are the differences between require and include, include_once and require_once? : Sql dba
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
Enlist the advantages of sql.
What is difference between sql and excel?
What is cursor and its types?
What company owns postgresql?
Is sql a scripting language?
Which kind of parameters cannot have a default value in pl sql?
Is primary key clustered index?
How can the performance of a trigger be improved?
Is sql similar to python?
what are ddl statements in mysql? : Sql dba
How many sql statements are used?
What does t sql mean?
What is indexing in sql and its types?