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

How to provide values to user defined function parameters?

1064

What are xml indexes?

1005

What is resource governor in sql server?

1049

What are key constraints?

1018

Do you know what guidelines should be followed to help minimize deadlocks?

1014

How much does sql server 2016 cost?

1159

What is the difference between join and inner join?

1074

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

943

Is foreign key unique?

1049

What are entities and relationships?

1024

What is a join in sql? What are the types of joins?

1194

Explain about builtinadministrator?

1117

What is the difference between index seek vs. Index scan?

1066

Explain in details security in SQL azure?

123

How to find the source of a table in sql server?

1039