wewewewewewr

0

Please login or register to vote for this query.

(click on this box to dismiss)

ef

Computational Science

Q&A for scientists using computers to solve scientific problems

create table #tbl(unique_ID int, worker_ID int, date int, type_ID int)
insert into  #tbl values
  (1,1,1,1),  (2,1,1,1), (3,1,3,1)
,(11,2,4,1), (12,2,7,1),(13,2,3,1)
,(21,3,1,1), (22,3,2,1),(23,3,3,1)

select unique_ID ,worker_ID from #tbl  order by unique_ID
 --union all 
-- select unique_ID ,worker_ID from #tbl  order by unique_ID desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results