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 types of exception?

873

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1039

What is mutating error?

906

How many indexes can be created on a table in sql?

984

How do you use collections in procedure to return the resultset?

2179

How do you bind variables in pl sql?

1033

what are the t string functions available in tsql? : Transact sql

944

Is left join same as inner join?

1019

What is a unique constraint?

1008

Explain about various levels of constraint.

881

Can we rollback after truncate?

979

What do you mean by stored procedures?

950

How many types of relationship are there?

973

How do I create a memory optimized filegroup?

903

Can sql function call stored procedure?

955