how to write the query to select the rows are in the order
of either 1,3,5,7... or 2,4,6,8,...
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
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
What is SQL Azure Fabric?
What is normalization and what are the advantages of it?
What are different types of database indexes?
When should you use an instead of trigger?
How to find the login name linked to a given user name?
What are the different types of replication you can set up in sql server?
Explain what is lock escalation?
How to receive returning result from a query?
What do you mean by sql server 2005 express management tools?
What is difference between standardization and normalization?
How to list all dsn entries on your local machine using odbc_data_source()?
What is explicit cursors?
What do you mean by tablesample?
What are the advantages of using stored procedures?