Interested to Buy Any Domain ? << Click Here >> for more details...
how do we find every fifth record in a table
- 14 Answers
- 18766 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 the difference between web edition and business edition?
What is a performance monitor?
How self join is different from outer join?
What's the information that can be stored inside a bit column?
What is analysis service repository?
how to overcome kernel isssues
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
What stored by the model? : sql server database administration
What are transactions and its controls?
What does man by sql wildcard characters in sql server?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
How to create a view on an existing table in ms sql server?
How you would rewrite the sql query to return the customerid sorted numerically?
