pcsoft.us.windevCopyright 2026, PC SOFT13 Apr 2015 19:32:00 Z13 Apr 2015 14:32:00 Zi am try this code to get data radom in over data base. that database in more then 1500 record but not get data random. that code is give output same recode in many time run this code... please help me. SELECT QuestionMaster.QuestionMasterID AS QuestionMasterID, QuestionMaster.QM_SM_Id AS QM_SM_Id, QuestionMaster.QM_CM_ID AS QM_CM_ID, QuestionMaster.QM_DetailQuestion AS QM_DetailQuestion, QuestionMaster.QM_Name AS QM_Name, QuestionMaster.QM_AnsA AS QM_AnsA, QuestionMaster.QM_AnsB AS QM_AnsB, QuestionMaster.QM_AnsC AS QM_AnsC, QuestionMaster.QM_AnsD AS QM_AnsD, QuestionMaster.QM_CurrectAns AS QM_CurrectAns, QuestionMaster.QM_Remark AS QM_Remark, RANDOM( ) AS ra FROM QuestionMaster WHERE QuestionMaster.QM_SM_Id = {Param1} AND QuestionMaster.QM_CM_ID IN ({Param2}) ORDER BY ra ASC LIMIT 1030WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51490-random-data-record-get/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51490-random-data-record-get-51501/read.awp13 Apr 2015 19:32:00 Zthank you sir,https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51490-random-data-record-get-51501/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51490-random-data-record-get-51501/read.awpRandom data record get in dbguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51490-random-data-record-get-51497/read.awp13 Apr 2015 14:53:00 ZHi Vijay did you test my sugestion in your previous post regarding this issue? http://27130.foren.mysnip.de/read.php?27131,5…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51490-random-data-record-get-51497/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51490-random-data-record-get-51497/read.awpRandom data record get in db