Differences between UNIQUE and DISTINCT in select statements
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
Why do we use procedures?
What is the difference between an inner join and an outer join?
Can we rollback truncate?
What is the default isolation level in sql server? : Transact sql
What are the operators used in select statements?
what is “go” in t-sql? : Transact sql
How can I tell if sql is running?
what is a control file ? : Sql dba
Why do we go for stored procedures?
How to revise and re-run the last sql command?
How to convert comma separated string to array in pl/sql?
how to create a new table in mysql? : Sql dba
What are % type and % rowtype?
How can we make an if statement within a select statement?
what is clause? : Sql dba