how do we find every fifth record in a table
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
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What is filtered index?
Define synonym?
What are the differences between char and varchar in ms sql server?
Delete duplicate rows without using rowid.
Please differentiate between a local and a global temporary table?
what is the difference between openrowset and openquery?
What are the two modes of authentication in sql server?
How to verify a user name with sqlcmd tool?
How to sort the query output with order by clauses in ms sql server?
Why olap is used?
How do I view a script in sql server?
What is user-defined functions? What are the types of user-defined functions that can be created?
What are acid properties of transaction?
What is change data capture (cdc) in sql server 2008?