ID TempID
1234 2345
2342 8845
3455 9856
1863 9856
1752 4856用SQL语句怎么取出两条TempID=9856的记录
select id,tempid from a
group by id,tempid
having count(tempid)>1
order by tempid
怎么取不出来
1234 2345
2342 8845
3455 9856
1863 9856
1752 4856用SQL语句怎么取出两条TempID=9856的记录
select id,tempid from a
group by id,tempid
having count(tempid)>1
order by tempid
怎么取不出来
你的写的什么.不懂....
select id,tempid from a
where tempid=9856不行就报要求说明白点~