如何对视图进行排序?
我建立视图后用下面语句提取数据库内容,结果没有按TEMP排序,语句如下:
select * from ( select NAME,MOBILID,CENTERID,HOSTID,ERRORID, TEMP, OPTIONAL,OBJECT_NAME,OBJECT_ID,TIMEOUT,MSG ,ROWNUM num
from viewwebtrap
where object_id='$condition' and rownum < $end order by TEMP desc
)
where num > =$start
请大家帮帮忙!