The SQL expression Select distinct T, branch_name from branch T, branch S…

PYQ UGC NET 2013

The SQL expression

Select distinct T, branch_name from branch T, branch S

where T.assets>S.assets and S.branch_city=”Mumbai” finds the names of

  1. A.

    All branches that have greater assets than some branch located in Mumbai.

  2. B.

    All branches that have greater assets than all branches in Mumbai.

  3. C.

    The branch that has greatest asset in Mumbai.

  4. D.

    Any branch that has greater assets than any branch in Mumbai.

Attempted by 176 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…