Interested to Buy Any Domain ? << Click Here >> for more details...
how do we find every fifth record in a table
- 14 Answers
- 18742 Views
- Aspire, HCL, I also Faced
- E-Mail Answers
Answer Posted / nataraj m
select * from employees where eid = (select max(eid) from
employees where eid in (select top 5 * from employees))
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
How do we know if any query is retrieving a large amount of data or very little data?
What is an index in a database?
What is NOT NULL Constraint in sql server 2012?
How to find out the list schema name and table name for the database?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
What is join and name different type of joins?
What is the size of transaction log file?
Explain system functions or built-in functions? What are different types of system functions?
How to delete duplicate rows in sql server?
What are the functions in sql server?
How to invoke a trigger on demand?
How to create a ddl trigger using "create trigger" statements?
What do you mean by sql server 2005 express management tools?
Can you explain what are various ways to enhance the ssrs report?
How do I run a trace in sql server?
