Select Top 1 * From (Select Top 5 * From customer Order By 1 Desc) As X

how do we find every fifth record in a table

Question Posted / divya mahendra sikarwar

14 Answers
18254 Views
Aspire, HCL, I also Faced
E-Mail Answers

Answer Posted / divya mahendra sikarwar

Select Top 1 * From (Select Top 5 * From customer Order By
1 Desc) As X

Is This Answer Correct ?

2 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain what are the different index configurations a table can have?

1036

What is a cache in ssrs?

127

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1799

What are the ways available in sql server to execute sql statements?

1036

What is the difference between local and global temporary tables?

1073

What is sql azure database?

204

How can sql server instances be hidden?

891

Explain Geometry datatype in sql server 2008 with example

915

What happens if time-only values are provided as date and time literals?

952

What stored procedure can you use to display the current processes?

832

What is the ‘fillfactor’?

913

What is the security principal at the server level that represents your session?

962

Explain can SSRS reports Cache results?

149

How to turn on the mssql api module in php?

1010

Can primary key be null?

876