select * from employee where employeeID % 5=0

how do we find every fifth record in a table

Question Posted / vijaya

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

Answer Posted / vijaya

select * from employee where employeeID % 5=0

Is This Answer Correct ?

4 Yes

13 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we use max in where clause?

983

How to convert a numeric expression from one data type to another?

1094

Explain various On-Delete options in a DB table. Which is the default option?

1532

Where cross join is used?

1029

Find columns used in stored procedure?

1038

What are audit control procedures?

1034

What is the downside of using udf?

1162

What is the security model used in sql server 2005?

1069

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1137

Explain about local stored procedure?

1029

What are trace files?

1004

You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

123

Equi join and non equi join is possible with sql server?

1096

Explain the database you used in your final year project?

1104

What are the disadvantages of primary key and foreign key in SQL?

1152