Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 134543 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 the difference between an inner and outer join?
What is pl sql and why it is used for?
What is the use of index in sql?
how to concatenate two character strings? : Sql dba
What is flag in sql?
What is oracle sql called?
What problem one might face while writing log information to a data-base table in pl/sql?
What is nosql db?
What are the operators in sql?
What is cte?
What is on delete restrict?
What does pragma mean?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
How would you reference column values before and after you have inserted and deleted triggers?
explain about mysql and its features. : Sql dba
