Skip to content

Instantly share code, notes, and snippets.

@tkMageztik
Created January 29, 2013 23:06
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tkMageztik/4668855 to your computer and use it in GitHub Desktop.
Save tkMageztik/4668855 to your computer and use it in GitHub Desktop.
Multiplica registros de una misma columna. Revisar este link para mayor información: http://stackoverflow.com/questions/5416169/mutiplication-aggregate-operator-in-sql
CREATE TABLE MULTIPLICACION_MISMA_COLUMA
(NUMERO DECIMAL(9,2))
INSERT INTO MULTIPLICACION_MISMA_COLUMA
VALUES (5.00)
GO
INSERT INTO MULTIPLICACION_MISMA_COLUMA
VALUES (5.00)
GO
INSERT INTO MULTIPLICACION_MISMA_COLUMA
VALUES (5.00)
GO
INSERT INTO MULTIPLICACION_MISMA_COLUMA
VALUES (5.00)
GO
INSERT INTO MULTIPLICACION_MISMA_COLUMA
VALUES (5.00)
GO
SELECT EXP(SUM(LOG(NUMERO))) FROM MULTIPLICACION_MISMA_COLUMA
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment