The SQL Expression Select distinct T. branch name from branch T, branch S…
PYQ UGC NET 2011Modified — slightly modified from the official paper; see the solution
The SQL Expression Select distinct T. branch name from branch T, branch S where T. assets > S. assets and S. branch-city = DELHI, finds the name of
- A.
all branches that have greater asset than any branch located in DELHI.
- B.
all branches that have greater assets than allocated in DELHI.
- C.
the branch that has the greatest asset in DELHI.
- D.
any branch that has greater asset than any branch located in DELHI.
Attempted by 40 students.
Sign up free to check your answer
Sign up freeLoading lesson…

