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

Is pl sql better than sql?

542


Explain the difference between sql and mysql.

554


how to drop an existing view in mysql? : Sql dba

555


column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

6051


how is myisam table stored? : Sql dba

598






What is delete command in sql?

545


what is a trigger? : Sql dba

568


Why do we need a foreign key?

541


What is the location of pre_defined_functions.

636


Why do you partition data?

527


what is a stored procedure? : Sql dba

543


What types of commands can be executed in sql*plus?

542


What is basic structure of pl sql?

490


Where do we use pl sql?

545


What is the difference between jpql and sql?

545