问个很简单的SQL问题！(100分)

Z

zzf888

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-01

• #1

我现用SQL语句实现！
怎么样取得一个表里的相同行！
比如一个人事表里的同名同姓的数据！

 

A

albin

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-01

• #2

select name from tablename group by name

 

Z

zzf888

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-01

• #3

倒！第一个回复竟然是这个回答！

 

B

blue_morning

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-01

• #4

select name
from table
group by name
having Count(*) > 2

 

D

D影子D

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-01

• #5

用游标可以吧

 

Y

yaya8163

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-01

• #6

select id,name
from table
group by name,id
having Count(*) > 1

 

K

kingdeezj

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-01

• #7

1、Select * from Table where Name='姓名';
2、Select * from Table where Name in
(Select name from table
group by name
having count(name)>=2)

 

B

blue_morning

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-01

• #8

select name
from table
group by name
having Count(*) > 2
不好意思，正确的是：
select name
from table
group by name
having Count(*) >= 2
测试环境sql server 2k, name字段是varchar类型

 

Z

zzf888

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-01

• #9

多人接受答案了。

 

L

liujunzhang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-01

• #10

select name
from table
group by name
having Count(*) > 1
这个就够 了