Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 127594 Views
- ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / vijay mohan reddy
Hi Howard Cheon,
you are currect... but we cant able to use
both DISTINCT and UNIQUE, if the select_list contains LOB,
LONG columns. It may not a difference.
Could anyone plz give some another major difference..
Thanks in Advance
Vijay Reddy.
| Is This Answer Correct ? | 9 Yes | 10 No |
Post New Answer View All Answers
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
Is foreign key mandatory?
What are sql functions? Describe in brief different types of sql functions?
What is snowflake sql?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
How to get help at the sql prompt?
What is dbo in sql?
Explain the insert into statements in sql?
Can we use ddl commands in pl sql?
What is latest version of sql?
what are the authentication modes in sql server? : Sql dba
How to pronounce postgresql?
How to change the order of columns in Oracle SQL Plus ?
How many tables can a sql database have?
How do you update a table in sql?
