Using Top N analysis.... select * from (select rownum rn, col1,col2,c

how do we find every fifth record in a table

Question Posted / santhi k

Answer Posted / santhi k

Using Top N analysis....

select * from (select rownum rn, col1,col2,col3 from
tablename) where mod(rn,5)=0;

Is This Answer Correct ?

1 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is Lock table in SQL?

1410

Can we add an identity column to decimal datatype?

943

Explain the difference between function and stored procedure?

898

How to generate create table script on an existing table in ms sql server?

1091

Explain alternate key, candidate key and composite key in sql server?

860

what is the information that can be stored inside a bit column? : Sql server database administration

902

List out different types of normalizations in sql server and explain each of them?

886

Explain how many types of relationship?

973

Can we call future method from trigger?

879

What is best institute to Learn DotNET And SQL in chennai?

2114

What are the disadvantages of primary key and foreign key in SQL?

1048

what is the difference between count(*) and count(1) ?

1027

Determine how to use the inserted and deleted pseudo tables?

929

How to check parameter value in stored procedure sql server?

912

Explain about unique identifier data type in sql server?

857