0

Please login or register to vote for this query.

(click on this box to dismiss)

Cайт вопросов и ответов для лингвистов и энтузиастов русского языка

CREATE table #yourtable
([Location] varchar(6), [Month] int, [Orders] varchar(13))
;
    
INSERT INTO #yourtable
    ([Location], [Month], [Orders])
VALUES
    ('LAS', '6', '500'),
    ('ABQ', '6', '450'),
    ('PHX', '6', '425'),
    ('DEN', '6', '380'),
    ('LAS', '7', '500'),
    ('ABQ', '7', '450'),
    ('PHX', '7', '425'),
    ('DEN', '7', '380'),
    ('LAS', '8', '500'),
    ('ABQ', '8', '450'),
    ('PHX', '8', '425'),
    ('DEN', '8', '380')
;


select Orders
From #yourtable;

fork query

edited aug 17 18 anonymous

created jun 8 16 bluefeet