The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
x
+1 vote
68 views

 

I think answer is 0 , given answer is 3

asked in Databases by Active (4.4k points) | 68 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
49,540 questions
54,099 answers
187,269 comments
71,006 users