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

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

Please Help Members By Posting Answers For Below Questions

Explain the difference between delete,drop and truncate in SQL Server?

1018

How to drop an existing schema in ms sql server?

1021

What are the limitations/drawbacks or ssrs 2008 r2?

129

What is the difference between set and select?

1014

What is the name of reporting services config file and what’s it’s used for?

132

How to insert multiple rows with a subquery?

1059

can SSRS reports Cache results?

136

List the advantages of using stored procedures?

996

How much memory that we are using in Logshipping Concept?

1726

Describe different Processing Modes offered by SSRS?

232

What is Replication?

992

Tell me what is sql profiler?

978

Does group by sort data?

845

How do I create an extended event in sql server?

903

What is store procedure?

1004