۱۳۹۷ اردیبهشت ۰۹, ۰۶:۳۵ ب.ظ
SELECT codefard,class,(SELECT codefard,(sum(CASE
WHEN zarib>0 THEN nomre*zarib
ELSE 0
END)/sum(zarib)) as moadel FROM daneshjo GROUP BY codefard ORDER BY moadel DESC )as moadel,
IF([email protected]_last_ave,@curRank:[email protected],@curRank:[email protected]_sequence) AS rank,
@_sequence:[email protected]_sequence+1,@_last_ave:=moadel
FROM daneshjo, (SELECT @curRank := 1, @_sequence:=1, @_last_ave:=0)as r
ORDER BY moadel DESC
ولی این اخطار را میده:
SELECT codefard,class,(SELECT codefard,(sum(CASE
WHEN zarib>0 THEN nomre*zarib
ELSE 0
END)/sum(zarib)) as moadel FROM daneshjo GROUP BY codefard ORDER BY moadel DESC )as moadel,
IF([email protected]_last_ave,@curRank:[email protected],@curRank:[email protected]_sequence) AS rank,
@_sequence:[email protected]_sequence+1,@_last_ave:=moadel
FROM daneshjo, (SELECT @curRank := 1, @_sequence:=1, @_last_ave:=0)as r
ORDER BY moadel DESC LIMIT 0, 25
MySQL said: Documentation
#1241 - Operand should contain 1 column(s)
WHEN zarib>0 THEN nomre*zarib
ELSE 0
END)/sum(zarib)) as moadel FROM daneshjo GROUP BY codefard ORDER BY moadel DESC )as moadel,
IF([email protected]_last_ave,@curRank:[email protected],@curRank:[email protected]_sequence) AS rank,
@_sequence:[email protected]_sequence+1,@_last_ave:=moadel
FROM daneshjo, (SELECT @curRank := 1, @_sequence:=1, @_last_ave:=0)as r
ORDER BY moadel DESC
ولی این اخطار را میده:
SELECT codefard,class,(SELECT codefard,(sum(CASE
WHEN zarib>0 THEN nomre*zarib
ELSE 0
END)/sum(zarib)) as moadel FROM daneshjo GROUP BY codefard ORDER BY moadel DESC )as moadel,
IF([email protected]_last_ave,@curRank:[email protected],@curRank:[email protected]_sequence) AS rank,
@_sequence:[email protected]_sequence+1,@_last_ave:=moadel
FROM daneshjo, (SELECT @curRank := 1, @_sequence:=1, @_last_ave:=0)as r
ORDER BY moadel DESC LIMIT 0, 25
MySQL said: Documentation
#1241 - Operand should contain 1 column(s)