select * from dbo.outs_OpenItems where OIR

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 / senthil

Answer Posted / senthil

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

Is This Answer Correct ?

20 Yes

9 No

Please Help Members By Posting Answers For Below Questions

Explain the third normal form(3nf)?

983

What is difference between temp table and cte?

1074

what is the primary use of the model database? : Sql server administration

1097

What are the recovery models for a database?

1149

What is the default schema of your login session in ms sql server?

1095

What is the difference between SQL notification and SQL invalidation?

1267

Tell me the difference between clustered and non-clustered index?

992

What are data driven subscriptions?

115

What are the components of dbms?

998

Can we hide the definition of a stored procedure from a use?

1299

Write a sql query to sort on different column name according to the parameters passed in the function?

964

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

948

How to enforce security in sql server? : sql server security

1162

List out a number of the wants to setup a SQL Server failover cluster?

1126

What is full outer join in sql server joins?

1141