For 1,3,5,7... select * from emp where (rowid,1) in (select rowid,mod

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 / vijayplsql@gmail.com

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

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why people hate cursor?

1151

Write a program using SQL queries to find a unique entry in a table.

1000

New concepts of sql server 2005 use in your project.

2365

What do you mean by acid?

1007

What are the export options of ssrs?

173

What function does a database engine serve in the sql server?

1043

What is a linked server in sql server?

1080

What is catalog views?

1074

What do you mean by sql server agent?

999

What is transact-sql ddl trigger?

1113

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

1029

What is nonclustered index with included columns ?

970

Can we call future method from trigger?

947

What is trigger and different types of Triggers?

1152

How to create new tables with "create table" statements in ms sql server?

1070