Differences between UNIQUE and DISTINCT in select statements
Answer Posted / carol
unique is a constraint on coloumnsbut distinct is used in DML for query retrieval in select
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are sql data types?
How do I view tables in mysql?
what is the command used to fetch first 5 characters of the string? : Sql dba
What is duration in sql profiler trace?
What is example of database?
What are the ddl commands?
What are the advantages of sql?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
what is the difference between a having clause and a where clause? : Sql dba
how to analyze tables with 'mysqlcheck'? : Sql dba
How do I debug a stored procedure?
Is sql open source?
What is the difference between in and between in sql?
What is not equal in sql?
how to dump a table to a file with 'mysqldump'? : Sql dba