一条pl sql语句。。。

[dafuw]

select id from foa_wj where id = (select top 1 id from foa_wj);

这条语句应该怎么改？？？

[suncrafted]

[Quote=引用楼主 xuetao365 的帖子:]
SQL code
select id from foa_wj where id = (select top 1 id from foa_wj);



这条语句应该怎么改？？？
[/Quote]

取出第一条：
select id from foa_wj where rownum = 1 ;
取出最大的id：
select id from(
select id from foa_wj order by id desc )
where rownum = 1 ;

[banana_97]

是啊.為什么沒有TOP一樣的功能?

[welyngj]

select id from foa_wj where id = (select id from foa_wj where rownum<2);

[dafuw]

逻辑可能不太对，要的是这种写法。。。

[请输入...]

select id from foa_wj where rownum=1

[qwe7759567]

你的意思不就是查第一条吗

[软猫克鲁]

原语句：select top 1 id from foa_wj

的排序顺序需要关心一下。如果两个数据库的索引、数据等完全一致可以考虑2楼的回复。

[inthirties]

[Quote=引用楼主 xuetao365 的帖子:]
SQL code

select id from foa_wj where id = (select top 1 id from foa_wj);


这条语句应该怎么改？？？
[/Quote]

你是不是去最大id的值的记录

select id from foa_wj where id = (select id form foa_wj order by id desc where rownum < 2)

[cab1225]

select id from foa_wj where id = (select id form foa_wj order by id desc where rownum < 2)