Let us try one using : select distinct dept

Differences between UNIQUE and DISTINCT in select statements

Question Posted / chandrakant agrawal

Answer Posted / chandrakant agrawal

Let us try one using :

select distinct dept_name
from departments;

What this query would return if dept_name column contains
NULL values.

Is This Answer Correct ?

3 Yes

11 No

Please Help Members By Posting Answers For Below Questions

Why do we need a foreign key?

1164

Does pdo prevent sql injection?

988

What are different types of statements supported by sql?

1206

What is primary key sql?

1107

What are conditional predicates?

1114

What is sql*loader?

1281

What are the different types of a subquery?

1100

What is pragma in pl sql?

1180

what is view? : Sql dba

1026

what is the difference between $message and $$message? : Sql dba

1039

How show all rows in sql?

1057

How do I find duplicates in a single column in sql?

1065

What is sql partition?

1160

What are pl sql procedures?

1077

what are date and time intervals? : Sql dba

1099