a) The query is syntactically wrong
b) The query gives all the possible student names where a finite value exists for ID
c) The query gives the names of the students that have a null ID and it also excludes identical names
d) The query gives the student names where a finite value exists for ID and it excludes identical names
Observe the following query and choose the correct option SELECT DISTINCT name FROM student WHERE ID IS NOT NULL;
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Observe the following query and choose the correct option SELECT DISTINCT name FROM student WHERE ID IS NOT NULL;
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!