Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table temp
- (
- id int identity(1,1),
- a decimal(6,2),
- b decimal(6,2),
- c decimal(6,2),
- d decimal(6,2),
- e decimal(6,2),
- f decimal(6,2),
- g decimal(6,2),
- h decimal(6,2),
- i decimal(6,2),
- j decimal(6,2),
- k decimal(6,2),
- l decimal(6,2),
- m decimal(6,2),
- n decimal(6,2),
- o decimal(6,2),
- p decimal(6,2),
- q decimal(6,2),
- r decimal(6,2),
- s decimal(6,2),
- t decimal(6,2),
- u decimal(6,2)
- )
- insert into temp
- (a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u)
- values
- (1,5,6,7,8,2,6,3,4,5,2,1,6,5,7,8,2,7,6,2,8)
- insert into temp
- (a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u)
- values
- (1,5,6,7,8,2,2,3,2,4,2,1,4,5,9,8,2,7,6,2,8)
- insert into temp
- (a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u)
- values
- (1,5,6,7,8,2,6,3,4,5,2,1,6,5,7,8,2,7,6,2,8)
- Median
- ======
- first row - 5.00
- second row - 4.00
- third row - 5.00
Add Comment
Please, Sign In to add comment