Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 13828 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
Explain SSRS Architecture?
How to change a login name in ms sql server?
What happens if an integer is too big for int date type?
What is "scheduled jobs" or "scheduled tasks"?
What is a scheduled job or what is a scheduled task?
Does the order of columns in update statements matter?
Do you know what are pages and extents? : SQL Server Architecture
What is a print index?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
Where are sql server usernames and passwords stored in the sql server?
Can two tables have the same primary key?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
how many no of arguments can be passed in procedures and functions
What are the ways available in sql server to execute sql statements?
