select * from employees where eid = (select max(eid) from employees where

how do we find every fifth record in a table

Question Posted / nataraj m

14 Answers
18469 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

Please Help Members By Posting Answers For Below Questions

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?

1094

What is the difference between SQL notification and SQL invalidation?

1121

Can you get second highest salary from the table?

935

Explain what are partitioned views and distributed partitioned views?

913

How are the exceptions handled in sql server programming?

1030

Explain differences between web edition and business edition?

119

What is full outer join in sql server joins?

1011

What is inner join in sql server joins?

1002

What does null mean?

953

what are cursors? : Sql server database administration

1024

What is side by side migration in sql server?

1054

What is the difference between varchar and varchar types?

1028

What do you mean by subquery?

1051

List the advantages of using stored procedures?

1016

Can a cursor be updated? If yes, how you can protect which columns are updated?

1065