how do we find every fifth record in a table
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 difference between inner join and full join?
How to scale out a federation by Sql statement?
What are the filtered indexes?
What is difference between foreign key and unique key?
What do you need to connect php to sql server?
What is a hint?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
What is built-in/administrator?
Is INSTEAD OF trigger directly applicable to Table ?
Explain the concepts and capabilities of sql server?
How can you check the version of sql server?
What is collation?
What is reportserver and reportservertempdb ?
What is coalesce and check constraint in sql server?
How to find out what is the default collation in a database?