sql如何找出符合某个条件的第一个数据 比如我要得到语文80分的人select * from table a where a.yuwen=80但是如果很多人语文80分,我只要第一个数据,sql怎么写?谢谢 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SELECT * FROM table a WHERE a.yuwen = 80 AND rownum < 2; 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 我也放一个select * from (SELECT * FROM table a WHERE a.yuwen = 80 order by dbms_random.value) where rownum <= 1; select * from table a where a.yuwen=80 and rownum=1; select * from (SELECT * FROM table a WHERE a.yuwen = 80) awhere rownum =1; SELECT * FROM TABLE A WHERE A.YUWEN=80 AND ROWNUM=1; select * from table a where a.yuwen=80 and rownum <2; select top 1 * from table a where a.yuwen=80 关于ORACLE插入慢的问题 给分组内记录编号的sql该怎么写 Enterprise manager console打不开 新手,求助 将一个运行在sqlserver下的语句转换为能在oracle下运行的问题!!!急~~~~~~~ SQL2K DTS导入失败!用户名不存在 怎么解决!? sql横排问题,在线等待 view是实的还是虚的 请问使用oracle的触发器会不会降低数据库的性能? 不知道字段名如何取值 redhat5.2安装oracle10g因SID问题(十万火急在线等) oracle刚装好,有没有系统库系统表?
(
select a.*,row_number() over(partition by yuwen order by id) rn from table a where a.yuwen=80 )
where rn=1
select * from (SELECT * FROM table a WHERE a.yuwen = 80 order by dbms_random.value) where rownum <= 1;
(SELECT * FROM table a WHERE a.yuwen = 80) a
where rownum =1;