Register

DBMS question on SQL query (2)

767 views

1 Answer

Best answer
0 votes
0 votes
the answer is b .

because We cannot compare NULL in sql with " =" sign. In SQL's three-valued logic. neither NULL equals NULL nor NULL not-equals NULL is true. Testing whether a value is NULL requires an expression such as IS NULL or IS NOT NULL.

so all the other becomes invalid. option b will be the answer
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
0 answers
1
Tuhin Dutta asked Dec 15, 2017
413 views
DBMS sql query on null
Student table ROLLNO NAME MARKS1 MARKS2 1 T 50 30 2 S 70 99 3 D NULL 10 NULL NULL 78 NULL NULL NULL NULL NULL a) select count(MARKS1) from student; b) select count(*) from student;
Student tableROLLNONAMEMARKS1MARKS21T50302S70993DNULL10NULLNULL78NULLNULLNULLNULLNULLa) select count(MARKS1) from student;b) select count(*) from student;
User Avatar
1 votes
1 votes
2 answers
2
worst_engineer asked Oct 3, 2015
1,220 views
DBMS question on SQL query
Hi , I tried to solve it in this way -- inner query returning zero tuples. So , outer query becomes select * from table1 where not exists null ( i mean no tuple ). basically , it should give me all the tuples , right ? I know , i am wrong , please clarify.  
Hi , I tried to solve it in this way inner query returning zero tuples.So , outer query becomes select * from table1 where not exists null ( i mean no tuple ).basically...
User Avatar
1 votes
1 votes
1 answer
4
Shubhanshu asked Dec 24, 2018
1,322 views
Ace Test Series: DBMS - Correlated Sql Query
According to me it should be – “Retrieve the names of all students with a lower rank, than all students with age < 18 ”
According to me it should be – “Retrieve the names of all students with a lower rank, than all students with age < 18 ”
User Avatar
Link Copied!