SQL查询最新的数据

方法一：

SELECT
    *
  FROM
    table
  WHERE pro_id = '111' 
  AND create_time 
  	IN (
	  SELECT MAX(create_time) 
	 	 FROM 
   table)
 

方法二：

SELECT
    *
  FROM
        table
  WHERE pro_id = '111' ORDER BY create_time DESC LIMIT 1