how do we find every fifth record in a table
Answer Posted / vijaya
select * from employee where employeeID % 5=0
| Is This Answer Correct ? | 4 Yes | 13 No |
Post New Answer View All Answers
What is public role in sql server?
How to implement service broker?
What is subreport?
How to change the data type of an existing column with "alter table" statements in ms sql server?
Explain iaas, paas and saas?
Why can there be only one clustered index and not more than one?
What is sql azure database?
Does the unique constraint create an index?
Explain what you mean by 3 tier architecture.
How to convert numeric expression data types by assignment operations?
What is cursor in ms sql server?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
What the different components in replication and what is their use?
What is the difference between SQL notification and SQL invalidation?
how to control the amount of free space in your index pages? : Sql server database administration