> ÉÚ ÔÏÊ ÖÅ ÓÅÒÉÉ:
> ÅÓÔØ ÔÁÂÌÉÃÁ Label - 300000 ÚÁÐÉÓÅÊ
> ÐÏÌÅ Fullname 80 ÓÉÍ×ÏÌÏ×, ÉÎÄÅËÓÉÒÏ×ÁÎÎÏÅ
>
> ÚÁÐÒÏÓ
> select label.Id, label.Code, label.FullName
> from label
> where label.Fullname like '%ðïéóë%'
> order by label.Fullname
> ÷ FB1.5 ×ÙÐÏÌÎÑÅÔÓÑ ÎÅÓËÏÌØËÏ ÒÁÚ ÂÙÓÔÒÅÅ, ÞÅÍ × ×ÅÒÓÉÉ 2
>
> ÚÁÐÒÏÓ
> select label.Id, label.Code, label.FullName
> from label
> where label.Fullname like '%ðïéóë%'
> order by label.Fullname  || ''
> × ÔÏÍ ÖÅ FB2 ×ÙÐÏÌÎÑÅÔÓÑ × 50 ÒÁÚ ÂÙÓÔÒÅÅ ÞÅÍ ÐÒÅÄÙÄÕÝÉÊ
>
> ÐÒÏ ÓËÁÎÉÒÏ×ÁÎÉÅ ÉÎÄÅËÓÁ Ñ ÐÏÎÑÌÁ
> ÜÔÏ ÔÁË É ÂÕÄÅÔ ×ÓÅÇÄÁ? ÐÅÒÅÐÉÓÙ×ÁÔØ ÐÒÏÇÕ ÎÁ ÇÁÛÅÎÉÅ ÉÎÄÅËÓÏ×
> × ÓÏÒÔÉÒÏ×ËÅ?

ÐÒÏÄÏÌÖÕ ÓÁÍÁ Ó ÓÏÂÏÀ ;)
ÚÁÐÒÏÓ
select label.Id, label.Code, label.FullName
from label
where label.Fullname like 'ðïéóë%'
order by label.Fullname
 ÕÓÌÏ×ÉÅ ËÏÔÏÒÏÇÏ ÏÐÔÉÍÉÚÉÒÕÅÔÓÑ ÐÏ ÉÎÄÅËÓÕ ×ÙÐÏÌÎÑÅÔÓÑ ÍÇÎÏ×ÅÎÎÏ
Ô.Å. Ñ ÔÁË ÐÏÎÉÍÁÀ - ÇÁÓÉÔØ ÉÎÄÅËÓÙ ÎÕÖÎÏ ÐÏ ÔÅÍ ÐÏÌÑÍ × ÓÏÒÔÉÒÏ×ËÅ
ËÏÔÏÒÙÅ (ÉÎÄÅËÓÙ) ÎÅ ÉÓÐÏÌØÚÏ×ÁÎÙ × ÚÁÐÒÏÓÁÈ
ÔÁË?





Ответить