Добро пожаловать в форум, Guest >> Войти | Регистрация | Поиск | Правила | | В избранное | Подписаться | ||
Все форумы / Microsoft SQL Server |
![]() ![]() |
sijanna Member Откуда: Сообщений: 2 |
помогите, не пойму в чем ошибка, ругается на скобку (Неправильный синтаксис около конструкции ")".)SELECT Employee.* FROM (SELECT t FROM (SELECT E_phone_number AS t, (COUNT(E_phone_number)) AS A FROM Servicess GROUP BY E_phone_number) AS [%$##@_Alias] WHERE A=(SELECT MAX(A) FROM (SELECT E_phone_number AS t, (COUNT(E_phone_number)) AS A FROM Servicess GROUP BY E_phone_number)[color=red])[/color])AS numb, Employee WHERE Employee.E_phone_number=numb.t; |
22 май 15, 13:27 [17676474] Ответить | Цитировать Сообщить модератору |
WarAnt Member Откуда: Питер Сообщений: 2423 |
sijanna, Пятничный троль?
|
||
22 май 15, 13:29 [17676489] Ответить | Цитировать Сообщить модератору |
o-o
Guest |
какой-то ужас, но допишите алиас:SELECT Employee.* FROM (SELECT t FROM (SELECT E_phone_number AS t, (COUNT(E_phone_number)) AS A FROM Servicess GROUP BY E_phone_number) AS [%$##@_Alias] WHERE A=(SELECT MAX(A) FROM (SELECT E_phone_number AS t, (COUNT(E_phone_number)) AS A FROM Servicess GROUP BY E_phone_number)ttt))AS numb, Employee WHERE Employee.E_phone_number=numb.t; |
22 май 15, 13:29 [17676490] Ответить | Цитировать Сообщить модератору |
WarAnt Member Откуда: Питер Сообщений: 2423 |
sijanna, это хотели? SELECT Employee.* FROM ( SELECT t FROM ( SELECT E_phone_number AS t, (COUNT(E_phone_number)) AS A FROM Servicess GROUP BY E_phone_number) AS [%$##@_Alias] WHERE A=( SELECT MAX(A) FROM ( SELECT E_phone_number AS t, (COUNT(E_phone_number)) AS A FROM Servicess GROUP BY E_phone_number ) alias ) ) AS numb, Employee WHERE Employee.E_phone_number=numb.t ) Employee |
22 май 15, 13:39 [17676562] Ответить | Цитировать Сообщить модератору |
sijanna Member Откуда: Сообщений: 2 |
Всем спасибо, помогло)) |
22 май 15, 13:54 [17676680] Ответить | Цитировать Сообщить модератору |
Все форумы / Microsoft SQL Server | ![]() |