Interested to Buy Any Domain ? << Click Here >> for more details...
how do we find every fifth record in a table
- 14 Answers
- 19193 Views
- Aspire, HCL, I also Faced
- E-Mail Answers
Answer Posted / kumar.t
Table Name Is Employee
EmployeeId Is Identity field
Select * From Employee Where EmployeeId In (Select
EmployeeId From Employee Where EmployeeId%5=0)
by
Kumar.T
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
Can we take the full database backup in log shipping?
How to create an index on an existing table in ms sql server?
Which sql server table is used to hold the stored procedure scripts?
Sql server reporting services vs. Crystal reports.
What are unicode character string data types in ms sql server?
How to run queries with sql server management studio express?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
What is the difference between NOROW and LOCKROW?
Explain few examples of RDBMS?
List few advantages of stored procedure.
Where sql server user names and passwords are stored in sql server? : sql server database administration
What is a coalesce function?
How do I start sql server agent automatically?
What is the difference between upgrade and migration in sql server?
What happens if the update subquery returns multiple rows in ms sql server?
