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
What is the contrast between sql and mysql?
What are transactions in sql?
What are the encryption mechanisms in sql server?
What do you understand by integration services in sql server?
What is sql stored procedure?
In which format does an image save in SQL Server database ?
Explain the microsoft sql server delete command? : SQL Server Architecture
what are constraints? : Sql server database administration
What are distinctive joins find as a part of sql?
What do you mean by sql server agent?
Explain log shipping?
How to remove duplicate rows from table?
How to convert character strings into numeric values?
What is the main purpose of having conversation group?
What is the process of indexing?