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
- 13825 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
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
What are the built in functions in sql server?
Explain datetime2 data type in sal server 2008?
What are date and time data types in ms sql server?
State the difference between local and global temporary tables?
You want to implement the many-to-many relationship while designing tables. How would you do it?
What is the difference between stored procedure and user defined functions?
What is cube dimension? : sql server analysis services, ssas
what is a schema in sql server 2005? : Sql server database administration
What is surrogate key? : sql server analysis services, ssas
Define full outer join?
What does indexation mean?
Explain a differential backup?
What is stored procedures?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
