如何简单有效的剔除数据表中重复的冗余数据呢?
select
*
from
[表名]
where
objectid in (
select
max(objectid)
from
[表名]
group by
userid,createdate
)
and other option
select
*
from
[表名]
where
objectid in (
select
max(objectid)
from
[表名]
group by
userid,createdate
)
and other option