Table Name Is Employee EmployeeId Is Identity field Select * From Emp

how do we find every fifth record in a table

Question Posted / kumar.t

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

Answer Posted / kumar.t

Table Name Is Employee
EmployeeId Is Identity field

Select * From Employee Where EmployeeId In (Select
EmployeeId From Employee Where EmployeeId%5=0)

by
Kumar.T

Is This Answer Correct ?

1 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Define msdb database?

1030

How to insert stored procedure result into temporary table?

1017

What is query optimizer in sql server?

1027

How to create indexed view?

1047

What is sql server profiler?

1011

What is the difference between clustered and non-clustered indexes in ms sql server?

1003

How do I run sql server 2014?

1007

What is federation member?

116

What is the process of normalization?

1126

what is database replication? : Sql server database administration

1071

Tell me about builtinadministrator?

1001

Tell me something about security and sql azure?

114

Do you know the cursor optimization tips?

990

What is data source in connection string?

912

What is explicit mode in sql server?

1066