in Databases retagged by
591 views
2 votes
2 votes

is the explaination of given question correct?

Explanation:

Result of inner query is non empty because even no record satisfy where condition of inner query count(*) produces 1 record.

So, every record of R  where condition true

My question: how count getting 1 record?

in Databases retagged by
by
591 views

4 Comments

No count=0 and count= NULL are both different.
0
0

Pankaj Joshi 

what that 1 means, when count return 0?

0
0
1 tupple  
where count value is 0 in that tupple
0
0

Please log in or register to answer this question.

Related questions