Welcome to Sign in | Join | Help

Select fara UNION

  •  03-05-2013, 4:19 PM

    Select fara UNION

    Salut
    Am un table de forma
    data intrare explicatii
    2000 0 REPORT
    2001 100 ........
    2002 1 .........
    2002 -1 .........
    2003 10 ........
    .
    .
    2013 10 .........
    Trebuie sa selectez cele care au intrari (inclusive cu minus), sunt mai mici de 2013 dar si prima inregistrare care are 0 la intrari.
    Pana la urma am rezolvat-o cu un UNION dar ma interesa daca se poate dintr-un singur SELECT.
    Va multumesc
    Sorin Sandu
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems