The SQL expression Select distinct T. branchname from branch T, branch S where…
PYQ RPSC Programmer 2013
The SQL expression
Select distinct T. branchname from branch T, branch S where T. assets > S. assets and S. branchcity = “XYZ”
Finds the names of
- A.
All branches that have greater assets than some branch located in XYZ
- B.
All branches that have greater assets than all branches located in XYZ
- C.
The branch that has the greatest asset in XYZ
- D.
Any branch that has greater asset than any branch located in XYZ
Attempted by 1 students.
Sign up free to check your answer
Sign up freeLoading lesson…