Find The Names Of All Branches That Have An Asset Value Greater #559
This subjective question is related to the book/course
gs gs114 Relational Database Management System.
It can also be found in
gs gs114 Practical Questions Solved Past Paper No. 1.
Question 1: Find the names of all branches that have an asset value greater than that of each branch in Brooklyn.
where branch_city = ‘Brooklyn’);
Answer:
select branch_name from branch where assets > some(select assets from branchwhere branch_city = ‘Brooklyn’);
