Interested to Buy Any Domain ? << Click Here >> for more details...
how do we find every fifth record in a table
- 14 Answers
- 18264 Views
- Aspire, HCL, I also Faced
- E-Mail Answers
Answer Posted / shanmugam
with cte as(
select ROW_NUMBER() over (order by id) as serial,* from tablename
)
select * from cte where serial=5
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the synonym of join?
what is a correlated sub-query? : Sql server database administration
What is format parameter in ssrs?
where can you add custom error messages to sql server? : Sql server administration
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
what method you can use to reduce the overhead of Reporting Services data sources?
What are user-defined functions (udfs) in sql server?
How to find out what is the default collation in a database?
Explain atomicity?
What is the contrast between sql and pl/sql?
what are the core components of SSRS?
Define full outer join?
What are the different types of sql server replication? : sql server replication
What is the meaning of sql server?
Why transaction is important?
