Sql Select 0 1 0 1 sequence from database table

Question

I need to fetch output from given below table in 0 1 0 1 sequence .All other data at the end of table.

create table #Temp
(
    EventID INT IDENTITY(1, 1) primary key ,
    Value bit
)
INSERT  INTO  #Temp(Value) Values
(0),(1)
,(0),(0)
,(0),(0)
,(0),(0)
,(1),(1)
,(1),(1)
,(1),(0)
,(0),(0)
,(1),(1)
,(0),(1)

can u show a sample of the output you want @Gaurav – Aritra Bhattacharya Feb 25 '16 at 08:33 — Aritra Bhattacharya, Feb 25 '16 at 08:33

score 1 · Accepted Answer · answered Feb 25 '16 at 08:35

1

This is probably what you want:

select *
from #Temp
order by row_number() over (partition by Value order by EventID), Value

answered Feb 25 '16 at 08:35

dnoeth

59,503
4
39
56

**Thanks** @dnoeth . This is what exactly i needed. – Gaurav Feb 25 '16 at 08:43

Sql Select 0 1 0 1 sequence from database table

1 Answers1