- 博客(3)
- 资源 (1)
- 收藏
- 关注
RSS订阅转载 获取oracle数据库的用户名
select username from dba_users where username not in( SELECT NAME FROM (SELECT CID, CNAME, SCHEMA# FROM SYS.REGISTRY$ UNION ALL SELECT A.CID, CNAME, B.SCHEMA# FROM SYS.REGISTRY$ A, SYS.REGISTRY$S
2014-10-28 10:47:29
344
原创 sqlserver 类似Oracle rownum
With TTTTT AS(select * from USERS t) SELECT * from (select ROW_NUMBER() OVER(ORDER BY userid DESC) AS rn,* from TTTTT) as T where rn between 1 and 10
2014-10-14 17:34:52
580
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人