mysql话语改成oracle语句

mysql语句改成oracle语句

select x.id as id,x.siteName as siteId,s.site_name as siteName,x.flg as flg ,x.product as pt

from xj_inf x left join site1 s on x.siteName = s.site_id

group by x.id ,x.siteName ,s.site_name , x.flg, x.product

select x.id as id,x.siteName as siteId,s.site_name as siteName,x.flg as flg ,x.product as pt

from xj_inf x left join site1 s on x.siteName = s.site_id group by siteName,pt,flg

select x.id as id,x.siteName as siteId,s.site_name as siteName,x.flg as flg ,x.product as pt

from xj_inf x , site1 s where x.siteName = s.site_id group by siteName,pt,flg

相关文章：

你感兴趣的文章：

标签云：