recategorized by
4,341 views
3 votes
3 votes

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. All branches that have greater assets than some branch located in Mumbai
  2. All branches that have greater assets than all branches in Mumbai
  3. The branch that has greatest asset in Mumbai
  4. Any branch that has greater assets than any branch in Mumbai
recategorized by

2 Answers

Best answer
5 votes
5 votes

in query it should be select distinct T.branch_name

ans is A  the query will display the names of all  branches that have greater assets than some branch located in Mumbai

selected by
3 votes
3 votes

Answer A

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

Answer:

Related questions

1 votes
1 votes
2 answers
1
2 votes
2 votes
1 answer
2
go_editor asked Jul 24, 2016
2,142 views
Match the following $:$$\begin{array}{} \text{(a)} & \text{Create} & \text{(i)} & \text{The ER model} \\ \text{(b)} & \text{Select} & \text{(ii)} & \text{Relationship m...
2 votes
2 votes
1 answer
4