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 All branches that have greater assets than some branch located in Mumbai All branches that have greater assets than all branches in Mumbai The branch that has greatest asset in Mumbai Any branch that has greater assets than any branch in Mumbai Databases ugcnetcse-sep2013-paper3 databases sql + – go_editor asked Jul 23, 2016 recategorized Oct 19, 2018 by Pooja Khatri go_editor 4.3k views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
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 Sanjay Sharma answered Jul 23, 2016 selected Dec 25, 2016 by Arjun Sanjay Sharma comment Share Follow See 1 comment See all 1 1 comment reply Rajas Deshpande commented Sep 12, 2017 reply Follow Share Why some, why not all, and some means which 0 votes 0 votes Please log in or register to add a comment.
3 votes 3 votes Answer A All branches that have greater assets than some branch located in Mumbai sh!va answered Jul 23, 2016 sh!va comment Share Follow See 1 comment See all 1 1 comment reply abhinav kumar commented Feb 10, 2020 reply Follow Share Why some,why not all 0 votes 0 votes Please log in or register to add a comment.