how do we find every fifth record in a table
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 |
Post New Answer View All Answers
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
What is query cost in sql server?
What are cursors stored procedures and triggers?
What is attribute relationships, why we need it? : sql server analysis services, ssas
How to fetch the next row from a cursor with a "fetch" statement?
What structure can you implement for the database to speed up table reads?
What are the common performance issues in sql server?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
What do you understand by hotfixes and patches in sql server?
How to create a Master database in SQL server ?
Define inner join in sql server joins?
Explain differences between web edition and business edition?
Is ssrs support other database except ms sql server?
How to resolve the orphan use problem? : sql server security
Do comments need to go in a special place in sql server 2005?