這是sql
select a.aaz635,b.aaz636,a.*,b.* FROM ep61 a
join ep62 b
on a.aaz635 = b.aaz635
where 1 = 1
and b.aae601 in ('1', '0')
and a.aae596 <> '0'
and b.aae599 = '4028c69b6dafde16016db36937350012'
uj5u.com熱心網友回復：
完成：select ep.*from (select a.*,
b.*,
row_number() over(partition by a.aaz635 order by b.aaz636 desc ) sdafsda
FROM ep61 a
join ep62 b
on a.aaz635 = b.aaz635
where 1 = 1
and b.aae601 in ('1', '0')
and a.aae596 <> '0'
and b.aae599 = '4028c69b6dafde16016db36937350012') ep where ep.sdafsda = 1
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/18039.html
標籤：開發
上一篇：CentOS+Oracle19C+DG主從問題(高手請進)
下一篇：程式問題！