select b.* from (
SELECT @rownum:=@rownum+1 as rownum,a.* FROM (SELECT @rownum:=0) r,java_test_pro as a
) b where b.rownum=1;
实现方法
SELECT @rownum:=@rownum+1 as rownum,a.* FROM (SELECT @rownum:=0) r,java_test_pro as a
select b.* from (
SELECT @rownum:=@rownum+1 as rownum,a.* FROM (SELECT @rownum:=0) r,java_test_pro as a
) b where b.rownum=1;
实现方法
SELECT @rownum:=@rownum+1 as rownum,a.* FROM (SELECT @rownum:=0) r,java_test_pro as a