Assuming there are 3 columns in the table emp1 select id, name ,salary

how do we find every fifth record in a table

Question Posted / vicky

Answer Posted / vicky

Assuming there are 3 columns in the table emp1

select id, name ,salary from ( select id,name ,salary,
mod(rownum,5) as r from emp1) where r=0

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1072

What is query cost in sql server?

999

What are cursors stored procedures and triggers?

1024

What is attribute relationships, why we need it? : sql server analysis services, ssas

977

How to fetch the next row from a cursor with a "fetch" statement?

1075

What structure can you implement for the database to speed up table reads?

1209

What are the common performance issues in sql server?

933

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

997

What do you understand by hotfixes and patches in sql server?

998

How to create a Master database in SQL server ?

1102

Define inner join in sql server joins?

1064

Explain differences between web edition and business edition?

119

Is ssrs support other database except ms sql server?

142

How to resolve the orphan use problem? : sql server security

1026

Do comments need to go in a special place in sql server 2005?

866