SQL QUERY NOT EXISTS

Please log in or register to answer this question.

← Prev. Next →

← Prev. Qn. in Sub. Next Qn. in Sub. →

Related questions

0 votes

0 answers

1

204 views

SQL query with NOT IN connective.
a) 0 b) 1 c) 2 d) 3

a) 0 b) 1 c) 2 d) 3

asked Sep 15, 2018 in Databases Nirmal Gaur 204 views

0 votes

1 answer

2

381 views

Ace Test Series: DBMS - Correlated Sql Query
According to me it should be – “Retrieve the names of all students with a lower rank, than all students with age < 18 ”

According to me it should be – “Retrieve the names of all students with a lower rank, than all students with age < 18 ”

asked Dec 24, 2018 in Databases Shubhanshu 381 views

0 votes

0 answers

3

161 views

SQL Query
Suppose there are two tuples in Animals relation with different IDs but of same type and in Adoption table there is a tuple with an ID that matches with the ID of first tuple in Animal relation. AND during the query evaluation, the type of first tuple of the animal ... same type are also present in Adoption table . but the thing is given answer is also wrong here. Correct me if i'm wrong.

Suppose there are two tuples in Animals relation with different IDs but of same type and in Adoption table there is a tuple with an ID that matches with the ID of first tuple in Animal relation. AND during the query evaluation, the type of first tuple of the animal relation ... same type are also present in Adoption table . but the thing is given answer is also wrong here. Correct me if i'm wrong.

asked Dec 20, 2018 in Databases Ashwani Yadav 161 views

0 votes

2 answers

4

232 views

asked Jul 14, 2018 in Databases Na462 232 views

...