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
- 11861 Views
- ADP, Satyam, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / leo
with contactinfo as (
select contactid,firstname,row_number() over (order by
firstname)as row from person.contact
)
--select * from contactinfo where row % 2 =0
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Ways to improve the performance of a SQL Azure Database?
What stored by the master?
What are the pre-defined functions in the sql server?
How ssrs maintain security?
What are the differences between stored procedure and view in sql server?
Why variables called the most powerful component of ssis?
Explain four layers of abstraction microsoft architectured?
What is compound operators?
What is the language structure to add a record to a table?
Are semicolons required at the end of sql statements in sql server 2005?
What is a data collection table?
Why is replication required on the sql server?
What is join and name different type of joins?
What are the different types of stored procedures?
What is table join?
