1.

Compare DISTINCT and ALL keywords when used with SELECT command

Answer»

DISTINCT keyword is used to restrict the duplicate rows from the results of a SELECT statement. ALL keyword retains the duplicate rows, by default ALL keyword is use by SELECT statement. 



Discussion

No Comment Found

Related InterviewSolutions