Differences between UNIQUE and DISTINCT in select statements
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
What is dcl in sql?
Which is better trigger or stored procedure?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
How are functions and procedures called in PL/SQL?
What is the execution plan in sql?
What is the function that is used to transfer a pl/sql table log to a database table?
What is the use of partition by in sql?
Is json a nosql?
What does pl sql stand for?
what is bcp? When does it used? : Sql dba
What are tables and fields?
How do you create a unique index?
describe mysql connection using mysql binary. : Sql dba
how can we repair a mysql table? : Sql dba
What are the types of join in sql?