suppose i wrote query :select employees from employee where employeeid in(2,3,5,1)
then i want to fetch data according to 2,3,5,1 order. but it display 1 ,2,3,5 wise please help me?
"select m.MachineID,jobcode,Fault,Running,FaultLimitExceed,ProdCount from machinemaster m inner join machinestatuspara s " +" on m.machineid=s.machineid where m.machineid is not null and m.machineid in(2,1)";
ans:
'1', '1', '0', '0', '0', '2377', '00:57:42', '31-10-2014'
'2', '3', '0', '0', '0', '1492', '00:57:35', '31-10-2014'
but i want
'2', '3', '0', '0', '0', '1492', '00:57:35', '31-10-2014'
'1', '1', '0', '0', '0', '2377', '00:57:42', '31-10-2014'