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

Do you know what is a trace frag? Where do we use it?

556

You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

110

What do you mean by sql server 2005 express management tools?

788

What is Sqlpaging in SqlServer 2005 ?

658

What are the options which must be set to allow the usage of optimistic models?

513

How to convert numeric expression data types by assignment operations?

515

Why the trigger fires multiple times in single login?

723

How to query multiple tables jointly?

556

What is transaction server distributed transaction?

555

What are the different types of backups that exist?

676

what are the new features introduced in sql server 2000? : Sql server database administration

544

What is sql server schema compare? How we can compare two database schemas?

559

What are different types of subquery?

719

What is a data collection table?

540

What are the mathematical functions supported by sql server 2005?

546