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


Please Help Members By Posting Answers For Below Questions

What is the contrast between sql and mysql?

567


What are transactions in sql?

528


What are the encryption mechanisms in sql server?

554


What do you understand by integration services in sql server?

525


What is sql stored procedure?

576






In which format does an image save in SQL Server database ?

562


Explain the microsoft sql server delete command? : SQL Server Architecture

557


what are constraints? : Sql server database administration

499


What are distinctive joins find as a part of sql?

537


What do you mean by sql server agent?

518


Explain log shipping?

562


How to remove duplicate rows from table?

569


How to convert character strings into numeric values?

550


What is the main purpose of having conversation group?

476


What is the process of indexing?

496