怎样用SQL 语句选出某字段值相同的记录？(10分)

王

王建伟

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-16

• #1

怎样用SQL 语句选出某字段值相同的记录？
比如选出 ColumnName1 这个字段的值相同的记录。

 

W

WangBingBing

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-16

• #2

GZ

 

S

seven_918

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-16

• #3

SELECT * FROM Table WHERE ColumnName1 in (
SELECT A.ColumnName1
FROM (SELECT ColumnName1, COUNT(*) AS SL FROM Table GROUP BY ColumnName1) AS A
WHERE A.SL >= 2)

 

H

hb_wshsh

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-16

• #4

说清楚些

 

Y

ysai

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-16

• #5

select * from tab where ColumnName1 in(
select ColumnName1 from (
select ColumnName1,count(ColumnName1) as colcount from tab group by ColumnName1
) where colcount>1
)

 

王

王建伟

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-16

• #6

谢谢了。