sql - Select ascending and descending on the same field -

___________________ | field1 | field1 | |________|________| |      |   e    | |    b   |   d    | |    c   |   c    | |    d   |   b    | |    e   |      | |________|________| 

if possible sql selection upside table same field same table?

select t1.c, t2.c (     cte     (         select              c,             row_number() over(order c desc) n,             row_number() over(order c asc) m         @t     )     select t1.c, t2.c     cte t1     join cte t2 on t2.n = t1.m ) 

can this?

declare @t table ( c char(1) )  insert @t values ('a'),('b'),('c'),('d'),('e')  ;with cte (     select          c,         row_number() over(order c desc) n,         row_number() over(order c asc) m     @t )  select t1.c, t2.c cte t1 join cte t2 on t2.n = t1.m 

edit (for comment):

if don't want use cte write as

select t1.c, t2.c  (      select c         , row_number() over(order c asc) m      @t  ) t1 join (      select c         , row_number() over(order c desc) n     @t  ) t2 on t2.n = t1.m 

sqlfiddle demo