table name :test
fileds:id title
id title
1 a
2 b
3 a
4 d
Find the same filed of the title with one sql:
slect * from test where title (select title from test group by title having count(*)>1 )
有些公司去面试的时候他们好出一些这样的题目来考面试人:
table name :test
fileds:id title
id title
1 a
2 b
3 a
4 d
Find the same filed of the title with one sql:
slect * from test where title (select title from test group by title having count(*)>1 )
有些公司去面试的时候他们好出一些这样的题目来考面试人: