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

tell us something about heap tables. : Sql dba

872


Can triggers stop a dml statement from executing on a table?

841


Explain commit, rollback and savepoint.

802


What is record in pl sql?

819


What is data type in sql?

763


Is primary key clustered index?

722


What is the order of sql select?

797


How do we accept inputs from user during runtime?

769


Mention what is the plv (pl/vision) package offers?

885


Are subqueries better than joins?

755


How do you define a foreign key?

760


Show the cursor attributes of pl/sql.

811


What is sql table?

728


what is data integrity? : Sql dba

814


Is a view faster than a stored procedure?

751