SELECT A a, B || C b, D d, E e, F f, G g, H h, I i
FROM TABLEA
WHERE (F like UPPER('BMW') or G like UPPER('BMW') or H like UPPER('BMW') or
I like UPPER('BMW'))
如题,各位大神,这条SQL怎么优化下?
...全文
333打赏收藏
求高人优化SQL
SELECT A a, B || C b, D d, E e, F f, G g, H h, I i FROM TABLEA WHERE (F like UPPER('BMW') or G like UPPER('BMW') or H like UPPER('BMW') or I like UPPER('BMW')) 如题,各位大神,这条SQL怎么优化下?