EXTRACT com GROUP BY !
O q há de errado nesta view ?
CREATE VIEW meusDados( pMes, ppedValor )
AS
SELECT EXTRACT( MONTH FROM pedi.pediData ) as pMes, ppedValor
FROM pped
GROUP BY extract( month from pedi.pediData ) as pMes, ppedValor
está dando o seguinte error na linha.
GROUP BY extract( month from pedi.pediData ) as pMes, ppedValor
mensagem de erro.
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 5, char 10.
extract.
Por favor me ajudem..
Pedro.
CREATE VIEW meusDados( pMes, ppedValor )
AS
SELECT EXTRACT( MONTH FROM pedi.pediData ) as pMes, ppedValor
FROM pped
GROUP BY extract( month from pedi.pediData ) as pMes, ppedValor
está dando o seguinte error na linha.
GROUP BY extract( month from pedi.pediData ) as pMes, ppedValor
mensagem de erro.
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 5, char 10.
extract.
Por favor me ajudem..
Pedro.
Prstab
Curtidas 0
Respostas
Sremulador
14/04/2004
Tente assim
CREATE VIEW meusDados( pMes, ppedValor )
AS
SELECT EXTRACT( MONTH FROM pedi.pediData ) as pMes, ppedValor
FROM pped
[b:c1cab62e5c]GROUP BY pMes, ppedValor [/b:c1cab62e5c]
CREATE VIEW meusDados( pMes, ppedValor )
AS
SELECT EXTRACT( MONTH FROM pedi.pediData ) as pMes, ppedValor
FROM pped
[b:c1cab62e5c]GROUP BY pMes, ppedValor [/b:c1cab62e5c]
GOSTEI 0