The Gateway to Computer Science Excellence
+1 vote
69 views

 

I think answer is 0 , given answer is 3

in Databases by Active (4.9k points) | 69 views
0
Given answer is correct. 3 tuples will be returned. 1,3,5 from (1,20) (3,20) and (5,20) entries
0
yes anwer is 3 apply correlated query
0

@Kunal Kadian

@Chandrabhan Vishwa 1

Shoudnt the answer be 7 because the inner loop is executed once for each entry of the outer loop. 

also their is no distinct keyword.

so according to me the output of the above should be 1,1,3,3,1,5,5.

Please log in or register to answer this question.

Related questions

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
50,647 questions
56,466 answers
195,381 comments
100,309 users