常见的Sql面试时候笔试题:
select b.NAME
from baseinfo as b,loginfo as l
where l.ID=b.ID
group by b.NAME
order by count(l.ID) desc limit 10
常见的Sql面试时候笔试题:
select b.NAME
from baseinfo as b,loginfo as l
where l.ID=b.ID
group by b.NAME
order by count(l.ID) desc limit 10