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

What is implicit mode in sql server?

1027

What are the components of dbms?

906

can a table be moved to different filegroup? : Sql server administration

909

What do you think of this implementation? Can this be implemented better?

874

How to manipulate data from one table to another table ?

910

Does union all remove duplicates?

1015

What do you mean by an execution plan? How would you view it?

868

what are database files and filegroups? : Sql server database administration

884

Why do we backup Active Directory ?

995

Explain the truncate command? : SQL Server Architecture

1091

How do I view a stored procedure in sql server?

943

How to create a scrollable cursor with the scroll option?

926

Define model database?

932

Do you know what is a trace frag? Where do we use it?

955

How many cores do I need for sql server 2016?

847