Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 134507 Views
- ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / prabha
Distinct:
Its gives only the non duplicate values in a database table.
Unique:
The UNIQUE constraint uniquely identifies each record in a
database table.its similar to primary key.these values
cannot be repeated.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
how to fetch alternate records from a table? : Sql dba
What is over () in sql?
What's the difference between inner join and left join?
what is 'mysqlshow'? : Sql dba
what is union? : Sql dba
what are rollup and cube in t-sql? : Transact sql
How do I run a script in sql developer?
Explain what is sql?
What is a record in pl/sql?
What is an oracle stored procedure?
How to call a javascript function from pl sql?
What is sap sql?
Can %notfound return null after a fetch?
what is unique key constraint? : Sql dba
Does sap use sql?
