how to write the query to select the rows are in the order of either 1,3,5,7..

Categories >> Software >> Databases >> SQL Server
Suggest New Category

how to write the query to select the rows are in the order
of either 1,3,5,7... or 2,4,6,8,...

Question Posted / guest

7 Answers
13653 Views
ADP, Satyam, Tech Mahindra, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,.....

Answer / senthil

select * from dbo.outs_OpenItems where OIR_ID % 2=1

Is This Answer Correct ?

20 Yes

9 No

how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,.....

Answer / vijay sultampur

For 1,3,5,7...

select * from emp where (rowid,1) in (select rowid,mod
(rownum,2) from emp);

For 2,4,6,8,...

select * from emp where (rowid,0) in (select rowid,mod
(rownum,2) from emp);

Is This Answer Correct ?

7 Yes

0 No

how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,.....

Answer / rajesh verma

1> incase of 2,4,6,8,...

select col1,col2 from tab1 where col1 in
(Select case when Row_number() over (order by col1)%2=0
then col1 else 0 end from tab1)

2> in case of 1,3,5,7,....

select col1,col2 from tab1 where col1 in
(Select case when Row_number() over (order by col1)%2=1
then col1 else 0 end from tab1)

Is This Answer Correct ?

6 Yes

1 No

how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,.....

Answer / leo

with contactinfo as (
select contactid,firstname,row_number() over (order by
firstname)as row from person.contact
)
--select * from contactinfo where row % 2 =0

Is This Answer Correct ?

4 Yes

1 No

how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,.....

Answer / md. niyaz

For: 2, 4, 6, ......

select * from <Table_Name> where <Column_Name> % 2 = 0

==============Niyaz====================================

For: 1, 3, 5, ......

select * from <Table_Name> where <Column_Name> % 2 = 1

Is This Answer Correct ?

3 Yes

1 No

how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,.....

Answer / vijayplsql@gmail.com

For 1,3,5,7...

select * from emp where (rowid,1) in (select rowid,mod
(rownum,2) from emp);

For 2,4,6,8,...

select * from emp where (rowid,0) in (select rowid,mod
(rownum,2) from emp);

Is This Answer Correct ?

1 Yes

0 No

how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,.....

Answer / tiru

select * from
(select emp.ename, emp.age, (rownum+1) AS XX from employee
emp )
where remainder(XX,2) = 0;

select * from
(select emp.ename, emp.age, (rownum+1) AS XX from employee
emp )
where remainder(XX,2) = 1;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer