Register

Question on calculating the number of tuples in result of a database query

391 views

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

1 votes
1 votes
3 answers
1
sh!va asked Feb 8, 2017
1,191 views
Predict the number of tuples in SQL result
Consider the following relation instance myTable num1 num2 100 100 100 NULL NULL 100 NULL NULL Query 1: SELECT * FROM myTable WHERE num1 != NULL; Query 2: SELECT * FROM myTable WHERE num1 = NULL; If Query 1 returns m tuples and Query 2 returns n tuples, then 10m+n will be _____________
Consider the following relation instance myTablenum1num2100100100NULLNULL100NULLNULL Query 1:SELECT *FROM myTableWHERE num1 != NULL;Query 2:SELECT *FROM myTableWHERE num1...
User Avatar
0 votes
0 votes
2 answers
4
print asked Jan 21, 2022
480 views
What would be the result of this query
Source Made Easy Test Serires Can anyone please tell me the answer for this, with explaination. According to me it will give the customer who buy from atleast one store, but the answer given is customer who buy from all stores.
Source Made Easy Test SeriresCan anyone please tell me the answer for this, with explaination. According to me it will give the customer who buy from atleast one store, b...
User Avatar
Link Copied!