请问在SYBASE ASE中，如何SELECT前十条符合条件的纪录

[wangfang123]

select top 10 * from tablename
不行

[老吴子]

first:
set rowcount = 10
secoend:
select col_list
from tbl_list
where ...
order by ...
last:
set rowcount = 0

[hailong525]

select * from tablename where rownum<=10

[wangfang123]

我希望用一条语句解决的

风云的不行呀

[MicroMouse]

风云的在Oracle上可用。
在isql中，老吴子的正确。

[hailong525]

select * from tablename where rownum<=10 and 其他条件即可！

[wangfang123]

Invalid column name 'rownum'.

[weyoung]

Sybase不支持的

[westfly]

用多级select试试：
select top 10 * from (select * from tablename where columnname=value)

[Stingray]

在SQL中select top 10 * from table where ...或select top 10 * from (select * from tablename where ......)应该可以