select*from (select 考场号,考场号 from
TBL X
where
x.姓名 = 'zhang'
and X.性别= '男'
order by A desc ,B asc )a
where ROWNUM = 1
TBL X
where
x.姓名 = 'zhang'
and X.性别= '男'
order by A desc ,B asc )a
where ROWNUM = 1
(SELECT 考场号A,考场号B rownumber() over(ORDER BY 考场号A desc ,考场号B asc ASC) AS rn
FROM X
where
x.姓名 = 'zhang'
and X.性别= '男' ) AS a1
WHERE a1.rn=1我没有做测试,也不知道你用的是什么数据库。
不知道rownumber() over()能不能用。
则先排序,然后rownum按排序后编号,取rownum=1,则是排序后的第一条如果非主键
先rownum编号(按读取顺序),再排序,此时取rownum=1,未必是排序后的第一条对于非主键,需要两层sql,内层排序,外层取rownum=1
http://topic.csdn.net/u/20080827/17/5962849a-6504-4b4b-8d71-fcf9bf7f9664.html
就是取出表单中第一条记录;
TBL X
where
x.姓名 = 'zhang'
and X.性别= '男'
order by A desc ,B asc )a
where ROWNUM = 1
或者
select * from (select (表中的所有字段+num) from 表名)where num=1;肯定可以,不信你试一试!
select 考场号,考场号 from(select 考场号,考场号 from TBL X where x.姓名 = 'zhang' and X.性别= '男' order by A desc ,B asc) rownum=1
select 考场号,考场号 from(select 考场号,考场号 from TBL X where x.姓名 = 'zhang' and X.性别= '男' order by A desc ,B asc) where rownum=1