Guest User

Untitled

a guest
May 22nd, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.89 KB | None | 0 0
  1. create table temp
  2. (
  3. id int identity(1,1),
  4. a decimal(6,2),
  5. b decimal(6,2),
  6. c decimal(6,2),
  7. d decimal(6,2),
  8. e decimal(6,2),
  9. f decimal(6,2),
  10. g decimal(6,2),
  11. h decimal(6,2),
  12. i decimal(6,2),
  13. j decimal(6,2),
  14. k decimal(6,2),
  15. l decimal(6,2),
  16. m decimal(6,2),
  17. n decimal(6,2),
  18. o decimal(6,2),
  19. p decimal(6,2),
  20. q decimal(6,2),
  21. r decimal(6,2),
  22. s decimal(6,2),
  23. t decimal(6,2),
  24. u decimal(6,2)
  25. )
  26.  
  27. insert into temp
  28. (a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u)
  29. values
  30. (1,5,6,7,8,2,6,3,4,5,2,1,6,5,7,8,2,7,6,2,8)
  31.  
  32. insert into temp
  33. (a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u)
  34. values
  35. (1,5,6,7,8,2,2,3,2,4,2,1,4,5,9,8,2,7,6,2,8)
  36.  
  37. insert into temp
  38. (a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u)
  39. values
  40. (1,5,6,7,8,2,6,3,4,5,2,1,6,5,7,8,2,7,6,2,8)
  41.  
  42. Median
  43. ======
  44. first row - 5.00
  45. second row - 4.00
  46. third row - 5.00
Add Comment
Please, Sign In to add comment