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
14094 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

What is the difference between push and pull subscription? : sql server replication

1279

What is stored procedures?

1110

What is SQL Azure Fabric?

112

What is the osql utility?

1038

What is the difference between drop table and truncate table?

976

Can you leave a union at any time?

1109

What are the advantages of using a stored procedure?

1063

Can you name a few encryption mechanisms in sql server?

993

How do you delete a trigger?

1035

How optimize sql query with multiple joins in sql server?

957

How to provide values to stored procedure parameters in ms sql server?

1101

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

1098

How do I uninstall sql server 2014?

985

What are SSL and TSL protocols?

1034

What are the fixed server level roles? : sql server security

1225