Differences between UNIQUE and DISTINCT in select statements
Answer Posted / gourvendra singh
Buddy i dont found any difference in using distinct and
unique in the select statement, as both are performing same
operation in the select statement, almost every diff you
have discussed i want to add one that is u cant use
distinct in the create whereas unique u can.
Is This Answer Correct ? | 19 Yes | 9 No |
Post New Answer View All Answers
what is a trigger in mysql? Define different types of trigger. : Sql dba
Explain autonomous transaction.
How does a self join work?
Explain the select statement in sql?
What is a data manipulation language?
What is sqlexception in java?
Is stored procedure faster than query?
What is difference between my sql and sql?
what is data control language? : Sql dba
How do you create a db file?
What are the benefits of pl sql?
What is rename in sql?
Is sql a case sensitive language?
What are local and global Indexes and where they are useful.
How many triggers can be applied to a table?