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
- 14095 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
What is inner join in sql server joins?
What are the differences between having and where clause.
How many types of dimensions are there and what are they? : sql server analysis services, ssas
What is the primary use of the model database?
What is the difference between a fill factor of 100 and 0?
What is NOT NULL Constraint in sql server 2012?
What is dbcc updateusage?
What is partition in sql server?
What is a partitioned view?
Can you name some of the dml commands in sql?
What is conditional split?
What are the disadvantages of using querystrings to send data from one page to another?
What is a non-clustered index?
What is the difference between migration and upgradation in sql server?
How to restore performance issues and how to check?
