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
What is mssql?
After removing a table from database, what other related objects have to be dropped explicitly?
What is the difference between clustered and a non-clustered index?
How to receive output values from stored procedures?
How to use values from other tables in update statements in ms sql server?
difference between Clustered index and non clustered index ?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is proper subset of candidate key?
What is normalization 1nf 2nf 3nf?
What is primary key and example?
Give me any three differences between Truncate and Delete.
How to return the second 5 rows in ms sql server?
When would you prefer to have a minimum number of indexes?
Explain acid?
What is GUID in sql server?