mysql 去重查询最新的N条数据

见下文

select a.* FROM
(SELECT
					`t_softwarechangeinf_history`.`softwareID` AS `softwareID`,
					`t_softwarechangeinf_history`.`version` AS `version`,
					`t_softwarechangeinf_history`.`debugTime` AS `debugTime`,
					`t_softwarechangeinf_history`.`create_time` AS `create_time` 
				FROM
					`t_softwarechangeinf_history` 
					ORDER BY
					`t_softwarechangeinf_history`.`create_time` DESC 
				LIMIT 10000
				) as a
left JOIN (
SELECT
					`t_softwarechangeinf_history`.`softwareID` AS `softwareID`,
					`t_softwarechangeinf_history`.`version` AS `version`,
					`t_softwarechangeinf_history`.`debugTime` AS `debugTime`,
					`t_softwarechangeinf_history`.`create_time` AS `create_time` 
				FROM
					`t_softwarechangeinf_history` 
				ORDER BY
					`t_softwarechangeinf_history`.`create_time` DESC 
				LIMIT 10000
				) as b on a.softwareID=b.softwareID and a.create_time<b.create_time
				where b.softwareID is null