Given a QDEL table from the QSALE DB provide as many alterna

Given a QDEL table from the QSALE DB provide as many alternatives in SQL to select every fifth record. (Script below can be used in oracle or sql server)

Solution

Answer:

Select * FROM qdel WHERE delno%5 = 0

we will find modulus of record number . if it is 0 then we will select that record