大家看看下面两个sql有没有错误
1、sql= "select * from (select * from (select * from (
select cname,csex
from Net_FY_Company order by cname) where rownum <5*2) order by cname desc) where rownum <5 "
2、sql= "select * from (select * from (select * from (
select cname as 姓名,csex as 性别
from Net_FY_Company order by cname) where rownum <5*2) order by cname desc) where rownum <5 "
如果两个都是正确的，下面的代码又错在哪里，请大家帮我分析分析
<%
'asp代码
'如果此处是上面的第一句SQL，没问题
'如果是第二句SQL,就出错
xx= "select * from (select * from (select cname from (select cname from Net_FY_Company order by cname) where rownum <5*2) order by cname desc) where rownum <5 "
response.ContentType= "application/vnd.ms-excel "
set rs=conn.execute(xx)
%>
<table border= "1 " cellspacing= "0 ">
<tr>
<%
for i=0 to rs.fields.count-1
%>
<td width= "50 " align= "center " bgcolor= "#FFFFCC "> <%=rs(i).name%> </td>
<%next%>
</tr>
<%do while not rs.eof%>
<tr>
<%for i=0 to rs.fields.count-1%>
<td align= "center " > <%=rs(i)%> </td>
<%next%>
</tr>
<%
rs.movenext
loop
rs.close
%>
</table>
------解决方案--------------------
select * from (
select * from (
select * from (
select cname as 姓名,csex as 性别
from Net_FY_Company order by cname
)
where rownum <5*2
)
order by cname desc//order by 姓名 desc
)
where rownum <5
估计是这个吧!
------解决方案--------------------
不知是不是要加表別名
sql= "select * from (select * from (select * from (
select cname as 姓名,csex as 性别
from Net_FY_Company order by cname)t where rownum <5*2) tt order by cname desc) ttt where rownum <5 "
------解决方案--------------------
不知道你要的结果是什么
create table Net_FY_Company (cname varchar2(100),csex varchar2(10));
insert into Net_FY_Company
select 'aa ', 'boy ' from dual
union all
select 'bb ', 'boy ' from dual
union all
select 'cc ', 'boy ' from dual
union all
select 'dd ', 'girl ' from dual