select r.EQUCODE, r.POSITIONSTATUS, r.AddressType, r.RENTINGSTATUS, r.POSITIONSTATUS, r.notes, r.effectivedate, r.createtime, r.AB_TEST_TYPE from SCM_HX01_EquStatusRecord r left join SCM_HX00_EQUCARDHEAD h on r.EQUID = h.billid where h.equno in ('THX-PH00006MOBA-10457H', 'THX-PH00010MOBA-10457H', 'THX-PH00011MOBA-10457H', 'THX-PH00055MOBA-10457H', 'SHX-JG00616GS2646', 'SHX-WG00012AMWP 11.5-8100', 'SHX-JG21500JCPT1212HD', 'SHX-JG21501JCPT1212HD', 'SHX-JG21502JCPT1412HD', 'SHX-JG21503JCPT1008HD', 'SHX-JG21504JCPT1008HD', 'SHX-WG00014AMWP 11.5-8100', '苏ET6X38', 'SHX-S023', 'SHX-S062', 'SHX-SG00105S60X', 'SHX-SG00120660SJ', 'SHX-SG00128660SJ', 'SHX-SG00129660SJ', 'SHX-SG00175660SJ', 'SHX-SG00182660SJ', 'SHX-SG00189660SJ', 'SHX-SG00208860SJ', 'SHX-SG00224660SJ', 'SHX-SG00245S65', 'SHX-SG00324860SJ', 'SHX-SG00457660SJ', 'GHX-DJ00049PCF-450', 'GHX-DJ00046PCF-350', 'GHX-DJ00048PCF-450') and r.RENTINGSTATUS=9110 order by r.effectivedate desc, r.billid desc;
时间: 2024-01-03 11:04:30 浏览: 24
这是一个 SQL 查询语句,目的是查询名为 "SCM_HX01_EquStatusRecord" 的表中,某些设备的状态记录。其中包括设备编号、位置状态、地址类型、租赁状态、备注、生效日期、创建日期和 AB_TEST_TYPE。这些设备编号是在一个列表中指定的,且租赁状态为 9110。查询结果将按照生效日期和记录编号降序排列。