Advertisement
DulcetAirman

select all column with one column in reverse order???

Sep 1st, 2015
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.67 KB | None | 0 0
  1. CREATE TABLE [dbo].[gupta](
  2.     [a] [int] NULL,
  3.     [b] [int] NULL,
  4.     [c] [int] NULL
  5. ) ON [PRIMARY]
  6.  
  7.  
  8. INSERT INTO [Test].[dbo].[gupta]([a],[b],[c]) VALUES (1,2,3);
  9. INSERT INTO [Test].[dbo].[gupta]([a],[b],[c]) VALUES (4,5,6);
  10. INSERT INTO [Test].[dbo].[gupta]([a],[b],[c]) VALUES (7,8,9);
  11. INSERT INTO [Test].[dbo].[gupta]([a],[b],[c]) VALUES (10,11,12);
  12.            
  13.  
  14. select MAX(aX),MAX(bX), MAX(cY)
  15. from
  16. (
  17.     (
  18.       SELECT row_number() OVER (ORDER BY a ASC) n, a as aX, b as bX, -1 as cY
  19.       FROM [Test].[dbo].[gupta]
  20.     )
  21.     union all
  22.     (
  23.        SELECT row_number() OVER (ORDER BY a DESC) n, -1 as aX, -1 as bx, c as cY
  24.       FROM [Test].[dbo].[gupta]
  25.     )
  26. ) as U
  27. group by U.n;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement