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

How do I setup a local sql server database?

1070

What are the difference between primary key and unique key? : sql server database administration

990

What is buffer cash in sql server?

1204

How to use order by with union operators in ms sql server?

1065

What command do we use to rename a database?

1115

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

1053

Â Explain what is sql override for a source taLle in a mapping?

1055

What are different types of constraints?

968

What are differences in between sql server 2012 and sql server 2016?

1097

What is DCL?

1103

What are the main differences between #temp tables and @table variables and which one is preferred?

1134

What are basics of policy management?

1150

Can a trigger be created on a view?

992

What do you mean by a Composite primary key?

1187

What is a functions and types in sql server?

1147