Welcome to Sign in | Help

Re: Select fara UNION

  •  04-02-2013, 8:54 AM

    Re: Select fara UNION

    Dacă e vorba de query-ul scris de Cristi, atunci se poate rescrie fără UNION astfel:

    SELECT data, intrare, explicatii
    FROM (
    SELECT *, ROW_NUMBER() OVER (PARTITION BY intrare ORDER BY intrare) AS rownum
    FROM MyTable
    ) x
    WHERE data<>0
    OR intrare = 0 AND rownum=1

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