Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 134551 Views
- ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / narendrasai
UNIQUE: it is a constraint and it was created at the time of table creation, where as
DISTINCT: it is a word used at the time of selection.
So both are same, but usage of both the words are different
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the syntax and use of the coalesce function?
What sql does db2 use?
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 do I view a procedure in sql?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
Can we use delete in merge statement?
What is view explain with example?
What is the use of procedures?
Is stored procedure faster than query?
Why truncate is used in sql?
What is trigger in sql? Explain
What are conditional predicates?
How do I send sql query results to excel?
what is a primary key? : Sql dba
How do I run a program in pl sql?
