Conditions testing for ROWNUM values greater than a positive integer are always false. For example, this query returns no rows:SELECT * FROM employees
WHERE ROWNUM > 1;
WHERE ROWNUM > 1;
调试欢乐多
(
select col1,row_number() over (order by col1) r from table1
) a
where r>=5 and r<=10
NinGoo(宁哥)进展好快啊!!!
name varchar(8) not null,
userName varchar(6) not null,
pwd varchar(6) not null,
company varchar(40) not null,
address varchar(80),
phone varchar(12),
mobile varchar(13),
email varchar(20),
applydate varchar(30),
companytype varchar(18),
Introduce varchar(60),
log varchar(50),
website varchar(25),
reponsibility varchar(12),
primary key (userName)
)
能给个这张表的具体写法吗?
希望大家帮帮忙!
userName,
pwd,
company,
address,
phone,
mobile,
email,
applydate,
companytype,
Introduce,
log,
website,
reponsibility
from
(
select rownum no,tempuser.* from tempuser
)
where no between 5 and 10;