You can not put a distinct in the clause.
You can select distinct rows though:
select distinct b.institution from MyBank b where b.institution LIKE UPPER(:startsWith)
This gives all institutions attached to a MyBank matching the startsWith.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment