Differences between UNIQUE and DISTINCT in select statements

Answer Posted / ajeet

there is no diff between distinct and unique in user point
of view. both are same. same functionality. dont bother
about it use whatever you want....

Is This Answer Correct ?    4 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to use in conditions? : Sql dba

717


Which certification is best for sql?

751


discuss about myisam index statistics collection. : Sql dba

722


What mean sql?

759


How can we debug in PL/SQL?

880


Why truncate is faster than delete?

831


What are the possible values that can be stored in a boolean data field?

748


how to convert character strings to dates? : Sql dba

740


what are properties of a transaction? : Sql dba

791


How to write pl sql program in mysql command prompt?

750


Which is better cte or subquery?

741


Name three sql operations that perform a sort.

798


Does varchar need length?

727


Is primary key clustered or nonclustered?

766


Which is better stored procedure or query?

741