how do we find every fifth record in a table
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
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
What are alternate keys?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
How to create function with parameter in sql server?
How to install sql server 2005 express edition?
What is a join in sql? What are the types of joins?
How to find the service pack installed? : sql server database administration
What is difference between inner join and full join?
How can we call UDF(User Define Function) using C# code in ASP.net ?
How to find Duplicate Records In table?
What is dimension table? : sql server analysis services, ssas
What is parameterized reports in ssrs ?
How can I change procedure name in sql server?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
Why olap is used?