Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 136463 Views
- ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / satish parashar
After applying the unique clause all the value of column
will be sorted, But in distinct clause it only remove the
duplicacy from the table,not sorted the column value.
| Is This Answer Correct ? | 6 Yes | 15 No |
Post New Answer View All Answers
What is varchar sql?
What are the differences between implicit and explicit cursors?
Can we join 3 tables in sql?
what are the differences between binary and varbinary? : Sql dba
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
What do you mean by dbms? What are its different types?
What is the use of prepared statement?
What is nested table in pl sql?
Can you skip header records while loading? : aql loader
What are basic techniques of indexing?
What is a schema? How is it useful in sql servers?
Which one is better subquery or joins?
What are conditional predicates?
Why do we use procedures in pl sql?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
