Chaitanya

Chaitanya

  • NA
  • 58
  • 57.4k

Select random records from a table based on condition

Nov 7 2017 3:44 AM
Hi all I have a table which holds data and the table is as follows my requirement is to load some random questions based on the total time against DifId. If against 1 30 minutes was set I need to load question randomly so that total time should be equal to 30.
  1.   Id              Description      Time     DifId
  2.    1                  ABC           1         1
  3.    2                  ABC           5         1
  4.    3                  ABC           9         1
  5.    4                  ABC           10        1
  6.    5                  ABC           10        1
  7.    6                  ABC           2         1 

Answers (3)