Dark Mode

Recent questions tagged nested-query-with-correlation

0 votes

2 answers

1

ISI 2016 PCB C4
Commodity items have some positive or negative changes in their prices each week. Each trading company picks a portfolio of com- modity items, that is, they have one or more items and they own some non-zero quantity of each one. The database table for this ... other items and there exists at least one company selling that item only (i.e., not selling any other item) in that week

Devasish Ghosh asked in Databases Mar 2, 2017

by Devasish Ghosh

594 views

1 vote

2 answers

2

Virtual Gate Test Series: Databases - Sql Query
Consider the following instances $R.$ A 1 2 3 4 B Null 1 2 2 The number of tuples returned by the following $\text{SQL query}$ is$?$ $>$select $*$ from $R$ as $R_{1}$ where not exists$($select $*$ from $R$ where $B = R_{1}.A)$

Purple asked in Databases Jan 9, 2017

by Purple

498 views

2 votes

1 answer

3

reena_kandari asked in Unknown Category Nov 8, 2016

by reena_kandari

599 views

To see more, click for the full list of questions or popular tags.

Recent questions tagged nested-query-with-correlation