how do we find every fifth record in a table
- 14 Answers
- 15407 Views
- Aspire, HCL, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
What is attribute? : sql server analysis services, ssas
What is the difference between mysql and mysqli?
How to create a local temporary stored procedure?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
What is difference between index seek vs. Index scan?
What does the not null constraint do?
what is the difference between delete table and truncate table commands? : Sql server database administration
How to list all user defined functions in the current database?
What is sql server english query?
What is sleeping status in sql server?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What is msdb database? : SQL Server Architecture
what are the types of indexes? : Sql server database administration
Define outer join in sql server joins?
What is the use of group by clause?
