Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 135498 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
How to select 10 records from a table?
What are triggers in sql?
How can we optimize a sql query?
How do I turn a list into a table?
what are the different type of normalization? : Sql dba
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
Is left join and outer join same?
Does google use sql?
What is difference between inner join and cross join?
What is full form of rtm?
Which function is used to return remainder in a division operator in sql?
How many triggers can be applied to a table?
how to convert character strings to numeric values? : Sql dba
What is procedure function?
What are the uses of merge?
