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

What are the different types of triggers?

1128

How show all rows in sql?

1006

What is query optimization in sql?

974

What is difference between procedure and trigger?

969

What's the difference between a primary key and a clustered index?

982

how to extract a unit value from a date and time? : Sql dba

985

What is a record in a database?

1053

What are tables in sql?

1052

How do you truncate?

901

What is a temporal table?

921

How does sql profiler work?

1008

what are the properties and different types of sub-queries? : Sql dba

1024

when is the use of update_statistics command? : Sql dba

1037

how can we know the number of days between two given dates using mysql? : Sql dba

1040

What are joins in sql?

1036