这样可以取出表中连续的相同记录: create table a (login_sort number(10), username varchar2(50), errorlog number(1));select username from (select username,errorlog lead0,lead(errorlog,2) over(order by login_sort) lead2, lead(errorlog,1) over(order by login_sort) lead1 from a ) where lead0=lead1 and lead1=lead2
Failed_login_attempts:指定在帐户被锁定之前所允许尝试登陆的的最大次数
create table a (login_sort number(10),
username varchar2(50),
errorlog number(1));select username from
(select username,errorlog lead0,lead(errorlog,2) over(order by login_sort) lead2,
lead(errorlog,1) over(order by login_sort) lead1 from a ) where lead0=lead1 and lead1=lead2
Failed_login_attempts:指定在帐户被锁定之前所允许尝试登陆的的最大次数