查询使日期降序后怎样取出中间项

----------------------------------------------------------------------------------------------
select * from ziliao
----------------------------------------------------------------------------------------------
1  1 1 11 电影1 1 111 1111 2007-10-31 10:01:01.000  dianying1.jpg
2  2 2 22 电影2 2 222 2222 2007-10-31 10:01:02.000  dianying2.jpg
3  3 3 33 电影3 3 333 3333 2007-10-31 10:01:03.000  dianying3.jpg
4  4 4 44 电影4 4 444 4444 2007-10-31 10:01:04.000  dianying4.jpg
5  5 5 55 电影5 5 555 5555 2007-10-31 10:01:05.000  dianying5.jpg
6  6 6 66 电影6 6 666 6666 2007-10-31 10:01:06.000  dianying6.jpg
7  7 7 77 电影7 7 777 7777 2007-10-31 10:01:07.000  dianying7.jpg
8  8 8 88 电影8 8 888 8888 2007-10-31 10:01:08.000  dianying8.jpg
9  9 9 99 电影9 9 999 9999 2007-10-31 10:01:09.000  dianying9.jpg
-------------------------------------------------------------------------------------------------
select photo1 from ziliao order by time1 desc
-------------------------------------------------------------------------------------------------
dianying9.jpg
dianying8.jpg
dianying7.jpg
dianying6.jpg
dianying5.jpg
dianying4.jpg
dianying3.jpg
dianying2.jpg
-------------------------------------------------------------------------------------------------
新手求教  怎样单独取出 photo1 里面的 每项