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 is bind reference and how can it be created?

974

What is function and procedure?

990

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

953

What are the advantages of pl sql over sql?

969

how many sql ddl commands are supported by 'mysql'? : Sql dba

967

What is dcl in sql?

916

What is record in pl sql?

1022

How do I enable sql encryption?

975

What is a string data type in sql?

972

How do I find sql profiler?

889

What are the disadvantages of not performing database normalization?

1110

What are the two types of exceptions.

1114

How do you delete data from a table?

980

What is having clause in sql?

933

What are different types of queries in sql?

1056