Interested to Buy Any Domain ? << Click Here >> for more details...
how do we find every fifth record in a table
- 14 Answers
- 18273 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
Which sql server table is used to hold the stored procedure script?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
Explain intellisense for query editing
Can binary strings be used in arithmetical operations?
What are the purpose of Normalisation?
Is sql server difficult to learn?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
What is openxml in sql server?
Can a cursor be updated? If yes, how you can protect which columns are updated?
What is entity data services?
How many tables can be joined in SQL Server?
Explain the disadvantages/limitation of the cursor?
How to list all schemas in a database?
What is the difference between mysql and sql server?
What are indexers?
