Question

select top 6 * from Favorites where USR_ID="&rs2("id")&" 我要查询这个表里的不重复记录怎样做呀，

Answer 1

select distinct * from Favorites where ...

Answer 2

select top 6 * from Favorites where USR_ID="&rs2("id")&" group by usr_id

Answer 3

select top 6 distinct * from Favorites where USR_ID="&rs2("id")&""

Answer 4

distinct