Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 135680 Views
- ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / gvmahesh
unique is a constraint it's declare for preventing the data
duplication.we create it along with table creation.
DISTINCT is a clause it is used for retrieving the data
without duplication.but it can't prevent the data
duplication.It just hiding the duplicated data.
| Is This Answer Correct ? | 11 Yes | 3 No |
Post New Answer View All Answers
What is a column in a table?
How can you know that statistics should be updated?
How delete all data from table in sql?
How to change sql*plus system settings?
what is the difference between a local and a global temporary table? : Sql dba
What are different functions in sql?
What are primary key and foreign key and how they work?
Can we create table inside stored procedure?
Is sqlite free?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
What are character functions in sql?
Is sql low level language?
What is sql not null constraint?
What is implicit cursor in pl sql?
What is a temporal table?
