there is no diff between distinct and unique in user point of view. both a

Differences between UNIQUE and DISTINCT in select statements

Question Posted / ajeet

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

Please Help Members By Posting Answers For Below Questions

What is the difference between delete and truncate statement in sql?

1118

how many ways we can we find the current date using mysql? : Sql dba

1140

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3099

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1103

What is percent sign in sql?

1324

How do I count rows in sql?

1045

What is the requirement of self-join?

1203

What is a stored procedure in sql with example?

1195

Can function return multiple values in sql?

1095

How to call shell script from pl sql procedure?

1352

what are the limitations of identity column? : Transact sql

1158

Is a view faster than a stored procedure?

1006

how to concatenate two character strings? : Sql dba

1154

What is bulk collect in pl sql?

1149

Explain architecture of sql server notification services?

1103