Shulou(Shulou.com)06/01 Report--

On the basis of what we just saw.

insert into look values (2,'a',100);

insert into look values (3,'a',100);

insert into look values (4,'a',100);

insert into look values (5,'a',100);

insert into look values (6,'a',100);

insert into look values (7,'a',100);

insert into look values (8,'a',100);

insert into look values (9,'a',100);

insert into look values (10,'a',100);

insert into look values (11,'a',100);

insert into look values (12,'a',100);

insert into look values (13,'a',100);

insert into look values (14,'a',100);

insert into look values (15,'a',100);

insert into look values (16,'a',100);

insert into look values (17,'a',100);

insert into look values (18,'a',100);

insert into look values (19,'a',100);

insert into look values (20,'a',100);

SELECT * FROM look ORDER BY id DESC FETCH FIRST 3 ROWS ONLY;

SQL> SELECT * FROM look ORDER BY id DESC FETCH FIRST 3 ROWS ONLY;

ID NAME MONEY

---------- ---------- ----------

20 a 100

19 a 100

18 a 100

the top three

SQL> SELECT * FROM look ORDER BY id DESC FETCH FIRST 10 PERCENT ROWS ONLY;

ID NAME MONEY

---------- ---------- ----------

20 a 100

19 a 100

the top 10% of

SQL> SELECT * FROM look ORDER BY id DESC OFFSET 5 ROWS FETCH NEXT 5 ROWS ONLY;

ID NAME MONEY

---------- ---------- ----------

15 a 100

14 a 100

13 a 100

12 a 100

11 a 100

The first 5 records are ignored and the next 5 records of the table are displayed:

SELECT * FROM look ORDER BY id FETCH FIRST 5 PERCENT ROWS WITH TIES;

ID NAME MONEY

---------- ---------- ----------

1 a 100

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.