数据库 第2条

select top 1 * from (select top 2 * from table1 order by id desc) order by id asc

$sq1=select form “数据库”order by id desc limit0,2";
$result=mysql_query($sql);
$i=0;
while($rs=mysql_fetch_array()){
$i++;
$tem_arr[$i]=$rs;
}
倒数2条记录＝$tem_arr[1];

select * from tablename order by 排序字段 desc limit 1,1
limit 1,1就是从第一条起，去一条