how do we find every fifth record in a table
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
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?
What is the difference between SQL notification and SQL invalidation?
Can you get second highest salary from the table?
Explain what are partitioned views and distributed partitioned views?
How are the exceptions handled in sql server programming?
Explain differences between web edition and business edition?
What is full outer join in sql server joins?
What is inner join in sql server joins?
What does null mean?
what are cursors? : Sql server database administration
What is side by side migration in sql server?
What is the difference between varchar and varchar types?
What do you mean by subquery?
List the advantages of using stored procedures?
Can a cursor be updated? If yes, how you can protect which columns are updated?