Question

well guys i have this table i sorted by date and all the id are mixed now and i selected 20 first rows then want to get another 20 rows after the last one to make is more clear : ( SELECT * FROM switch ORDER BY from_date ASC )

id  what    employee    from_date
55  1   11223   2012-01-26
69  3   30182   2012-01-12
67  3   12312   2031-01-12
68  3   12312   2031-01-12
65  3   12312   2031-01-12
6   3   12312   2031-01-12
64  3   12312   2031-01-12
63  3   12312   2031-01-12
**62    3   12312   2012-01-31**
60  3   30182   2012-01-18
61  3   30182   2012-01-18
59  3   30182   2012-01-18
57  3   30182   2012-01-18
58  3   30182   2012-01-18

now i want to get 20 rows from this table after id=62 the output should give me:

60  3   30182   2012-01-18
61  3   30182   2012-01-18
59  3   30182   2012-01-18
57  3   30182   2012-01-18
58  3   30182   2012-01-18

Answer 1

不幸的是,我没有看到你重新命令的栏目,但是,这将为所有人服务。

SELECT *
FROM your_table_name
ORDER BY column_name ASC LIMIT 20, 20

This will return 20 rows after 20th row. In your case query will be:

SELECT * FROM switch ORDER BY from_date ASC LIMIT 20, 20

Answer 2

请进一步解释。你试图从桌子上走什么? 如果您按日期顺序排列,我假定你正试图根据日期收集数据。但是,你表示,希望id笑吗? 这或许是你所期待的......。

select top 20 * from [table] where [condition]
union all
select top 20 * from [table] where [condition]

- 行业、审判、审判!

友情链接