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

Paging query: one page is not fully displayed, and the sql request needs to be submitted by page.

Select query list from table name ~ join table 2on join condition where filter condition group by grouping field having condition order by sort limit starting index, number of entries; the index here starts at 0 or the number of limit entries

Characteristics: the relationship between the number of pages and entries

Select query list from table limit (page-1) * size,size; assumes that size=5 page starts indexing 10 2 5 3 10 so index location: (page-1) * 5

# case: query the first five items of employee information

SELECT * FROM employeesLIMIT 0pc5ntSelect * FROM employeesLIMIT 5

# case: inquire about employee information in articles 11 to 25

SELECT * FROM employeesLIMIT 10 and 15

# case: the top ten employees with bonus and higher salary

SELECT * FROM employeesWHERE commission_pct IS NOT NULLORDER BY salary DESCLIMIT 10

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.