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

 

I think answer is 0 , given answer is 3

asked in Databases by Active (2.8k points) | 61 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
1 answer
4
0 votes
0 answers
6
asked 1 day ago in Databases by pream sagar Active (1.1k points) | 9 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

47,080 questions
51,333 answers
177,707 comments
66,675 users