String SQL = “select * from public.t_bussiness_poi where founded_date in” +
“(select max(founded_date) from public.t_bussiness_poi group by address)” +
"order by id ";
SQL语句的应用 怎么查询优化——同一地址相同,名字不同,取出最新的数据。
最新推荐文章于 2024-09-10 17:41:54 发布
String SQL = “select * from public.t_bussiness_poi where founded_date in” +
“(select max(founded_date) from public.t_bussiness_poi group by address)” +
"order by id ";