how to write the query to select the rows are in the order
of either 1,3,5,7... or 2,4,6,8,...
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 nested stored procedure. Syntax and an example for create nested stored procedure?
How many triggers are possible per table?
Explain the creation and execution of a user-defined function in the sql server?
Explain external key management in sql server 2008
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.
Explain how does the report manager work in ssrs?
What do you understand by physical_only option in dbcc checkdb?
What is indexing in sql server with example?
How do I edit a stored procedure in sql server?
What command would you use to create an index?
What are the different authentication modes in sql server?
What is field with example?
Can you tell me some of the common replication dmv's and their use? : sql server replication
How many types of local tables are there in sql server?
If you want to send some data from access database to sql server database. What are different component of ssis will you use?