Observe the following query and choose the correct option

mhmadesk

Save to bookmark

2022-07-13

567

Medium

-2

Observe the following query and choose the correct option.

SELECT DISTINCT name 
FROM student
WHERE ID IS NOT NULL;

The query is syntactically wrong
The query gives all the possible student names where a finite value exists for ID
The query gives the names of the students that have a null ID and it also excludes identical names
The query gives the student names where a finite value exists for ID and it excludes identical names

Database, MCQ Questions, Database MCQ-questions,

mhmadesk

2022-07-13

need an explanation for this answer? contact us directly to get an explanation for this answer

(d).The query gives the student names where a finite value exists for ID and it excludes identical names

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)