Interested to Buy Any Domain ? << Click Here >> for more details...
how do we find every fifth record in a table
- 14 Answers
- 19173 Views
- Aspire, HCL, I also Faced
- E-Mail Answers
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 are Spatial data types in SQL Server 2008
What kind of problems occurs if we do not implement proper locking strategy?
What are the restrictions while creating batches in sql server?
How will you hide an attribute? : sql server analysis services, ssas
What is table-valued sub query?
Explain some stored procedure creating best practices or guidelines?
What is the tcp/ip port on which sql server runs?
What is the meaning of sql server?
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
How to test odbc dsn connection settings?
How to generate create table script on an existing table in ms sql server?
What is RMS migrations?
Give an example of why you would want to denormalize a database
What are binary string data types in ms sql server?
