〖Orz〗求一条sql语句

SELECT * FROM 'phome_ecms_news' WHERE classid = (SELECT classid FROM 'phome_enewsClass' where islast=1 RAND() limit 1) RAND() limit 1;

SELECT * FROM 'phome_ecms_news' WHERE classid IN    (  SELECT classid FROM 'phome_enewsClass' where islast=1 ORDER BY RAND() limit 1  )  ORDER BY RAND() limit 1;

                 
              
              
        
            
      
      
classid limit phome Rand enewsClassPHP课程HTML视频教程CSS视频JS视频教程Vue视频教程

      
声明：本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn核实处理。