how to write the query to select the rows are in the order
of either 1,3,5,7... or 2,4,6,8,...
- 7 Answers
- 11857 Views
- ADP, Satyam, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / senthil
select * from dbo.outs_OpenItems where OIR_ID % 2=1
| Is This Answer Correct ? | 20 Yes | 9 No |
Post New Answer View All Answers
What is a unique index?
What is RMS migrations?
What is stretch database in sql server?
how can a database be repaired? : Sql server administration
What do you do in data exploration
What are the different types of join?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
What is the importance of concurrency control?
Why use “nolock” in sql server?
what is a sub-report?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
How many replicas are maintained for each SQL Azure database?
What are parameterized reports?
Explain about link server in sql server?
What is the federation in sql azure?
