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
- 13856 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
Explain what is analysis service repository?
What is trigger and different types of Triggers?
How can sql server instances be hidden?
What are points to remember while using the fillfactor argument?
What happens if strings are casted into wrong code pages in ms sql server?
Can we add a cpu to sql server?
What is a fill factor?
What program is used to store the data source file?
Do you know what are acid properties?
What is a trace frag? Where do we use it?
How many types of attribute relationships are there? : sql server analysis services, ssas
How to create a new table in a given schema?
How to find tables without indexes?
Explain indexed views and partitioned view with their syntax.
Explain unique key in sql server?
