下面一个sql serve 2005的语句需要改到Oracle ,主要是top 1和 order by这个oracle中不支持,我自己才改了一个to_char,希望大伙帮帮忙,谢谢了。select item_code as 料号,
(select top 1 a.inner_no
from v_import_singletno a
where a.item_code = Test.item_code
and to_char(a.apply_date,'yyyy-mm-dd') between '2009-04-10' and '2009-04-10'
order by a.bms_singlet desc
) as 内部编号1,
max(bms_singlet) as 最高单重,
(select top 1 b.inner_no
from v_import_singletno b
where b.item_code = Test.item_code
and (TO_CHAR(b.apply_date,'YYYY-MM-DD') between '2009-04-10' and '2009-04-10'
order by b.bms_singlet asc
) as 内部编号2,
min(bms_singlet) as 最低单重,
avg(bms_singlet) as 平均单重
from v_import_singletno Test
where (TO_CHAR(apply_date,'YYYY-MM-DD') between '2009-04-10' and '2009-04-10')
and inner_no = '2'
and item_code = '12'
group by item_code
(select top 1 a.inner_no
from v_import_singletno a
where a.item_code = Test.item_code
and to_char(a.apply_date,'yyyy-mm-dd') between '2009-04-10' and '2009-04-10'
order by a.bms_singlet desc
) as 内部编号1,
max(bms_singlet) as 最高单重,
(select top 1 b.inner_no
from v_import_singletno b
where b.item_code = Test.item_code
and (TO_CHAR(b.apply_date,'YYYY-MM-DD') between '2009-04-10' and '2009-04-10'
order by b.bms_singlet asc
) as 内部编号2,
min(bms_singlet) as 最低单重,
avg(bms_singlet) as 平均单重
from v_import_singletno Test
where (TO_CHAR(apply_date,'YYYY-MM-DD') between '2009-04-10' and '2009-04-10')
and inner_no = '2'
and item_code = '12'
group by item_code
oracle中怎麼會不支持 order by 呢