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 oltp (online transaction processing)? : Sql dba
Why schema is used in sql?
What jobs use sql?
what is sql in mysql? : Sql dba
What will you get by the cursor attribute sql%notfound?
how do you control the max size of a heap table? : Sql dba
How do I remove sql plus from windows 10?
Can you call pl/sql package functions from within a fast formula?
What is sqlexception in java?
What is the primary key?
Can pl sql procedure have a return statement?
What does select count (*) mean in sql?
What is a string data type in sql?
What are sql queries used for?
Explain unique key in sql.