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 (3.2k 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

0 votes
0 answers
4
asked Jan 23 in Databases by pream sagar Active (1.7k points) | 106 views
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
48,564 questions
52,765 answers
183,387 comments
68,245 users