sql如何找出符合某个条件的第一个数据

[xaxia]

比如我要得到语文80分的人
select * from table a where a.yuwen=80
但是如果很多人语文80分，我只要第一个数据，sql怎么写?谢谢

[liusong_china]

SELECT * FROM table a WHERE a.yuwen = 80 AND rownum < 2;

[cosio]

select a.* from
(
  select a.*,row_number() over(partition by yuwen order by id) rn from table a   where     a.yuwen=80 )
where rn=1

[shiyiwan]

我也放一个

select * from (SELECT * FROM table a WHERE a.yuwen = 80 order by dbms_random.value) where rownum <= 1;

[amiksong]

select * from table a where a.yuwen=80 and rownum=1;

[ojuju10]

select * from
(SELECT * FROM table a WHERE a.yuwen = 80) a
where rownum =1;

[wxkang123]

SELECT * FROM TABLE A WHERE A.YUWEN=80 AND ROWNUM=1;

[inthirties]

[Quote=引用 1 楼 liusong_china 的回复:]
SQL codeSELECT*FROMtable aWHERE a.yuwen=80AND rownum<2;
[/Quote]

比较简洁。

[xuejelly]

[Quote=引用 4 楼 amiksong 的回复:]
select * from table a where a.yuwen=80 and rownum=1;
[/Quote]
同意这个

[tfpeixun]

select * from table a where a.yuwen=80 and rownum <2;

[bzcnc]

[Quote=引用 1 楼 liusong_china 的回复:]
SQL codeSELECT*FROMtable aWHERE a.yuwen=80AND rownum<2;
[/Quote]

这个就可以，还比较简单

[aykkk]

select top 1 * from table a where a.yuwen=80