1

把这四条sql语句从sqlsever变成oracle的sql语句,求帮忙

1、SELECT top 1 MENUID+1 from app_menu
ORDER BY CAST(MENUID AS int) desc

2、SELECT top 1 id,fileName,filePath,createTime,md5,fileSize FROM VIS_file WHERE md5=#md5#

3、 SELECT top 1 USERID,REALNAME,GENDER,OTEL,OEMAIL,QQ,OADDRESS FROM org_employee where OEMAIL =#email#

4、SELECT top 1 * FROM request_apply where apply_for_id=#applyId#

5、SELECT top 10 * FROM request_apply where request_state=2

查看全部
xxb2sq
xxb2sq
2015/09/18 06:20
  • oracle
  • sql
  • 点赞
  • 收藏
  • 回答
    私信

3个回复