Welcome to Sign in | Help

SELECT

  •  05-12-2009, 3:06 PM

    SELECT

    Salutare tuturor!

    Poate ma poate ajuta cinva!

    Am nevoie de o interogare mai coplicata. Am o tabela cu urmatoarele campuri:

    id, centrucost, nrbonuri

    Vreau sa aflu suma de nrbonuri pe sectii

    Eu am incercat ceva de genu

    select sum(nrbonuri) from BONURI...ang where centrucost = (select distinct(centrucost) from bonuri...ang)

    si primesc err asta

     Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

    Cred ca este o eroare la clauza where

    Multumesc
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems