希望从tenant_message表中查询租房信息,但是有的用户会一天发两到三条重复信息,希望可以在查询数据库时做一个去重,查询200条不同的数据,请问如何才能实现?
SELECT
tm.id, title, userID, rental, address, update_time, create_time,
rental_number, house_thumbnails, image_path, deposit,
rentForm, house_area, tme.app_image_path,
house_longitude, house_latitude
FROM tenant_message tm
LEFT JOIN tenant_message_extend tme
ON tm.id = tme.tid
ORDER by id ASC limit 0, 200