Welcome to Sign in | Help

Re: Select fara UNION

  •  04-01-2013, 8:47 PM

    Re: Select fara UNION

    Presupun ca aveti ceva de genul:

    SELECT data, intrare, explicatii
    FROM MyTable
    WHERE data<2013 AND intrare<>0
    UNION
    SELECT TOP 1
    data, intrare, explicatii
    FROM MyTable
    WHERE intrare = 0

    Cristian Andrei Lefter, SQL Server MVP
    MCT, MCSA, MCDBA, MCAD, MCSD .NET,
    MCTS, MCITP - Database Administrator SQL Server 2005
    http://sqlserver.ro
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems