有一个表(表A)中包含姓名、成绩两个字段

admin

请写一个sql语句查询出成绩大于60分的，姓名有重复的人的姓名

java49-37

select name,count(1)

from a

where grade>60

group name

having count(1)>=2

撸天啦

create table test(
   id varchar2(10),
   name varchar2(10),
   grade number
);


insert into test values('001','tom',60); 
insert into test values('002','bom',70); 
insert into test values('003','tom',80); 

commit;

select name,count(name) from test where grade>60 group by name having count(name)>1

HYL

select name where grade>60 group by name having count(1)>1;

杜永亮

select name from

(select name,score from A score >60) B group by name having count(name)>2  

桃子++

select name from A wher score>60 group by name having count(name)>1

WR

select name count(1) from A where count>60 group by name having count(name)>1

song

//创建表

create table A (

 name varchar2(5),
 grade varchar2(4)
)

//向表中插入数据

insert into A values ('a','98')
insert into A values ('a','88');
insert into A values ('a','50');
insert into A values ('b','79');
insert into A values ('b','60');
insert into A values ('c','88');

//查询出成绩大于60分的，姓名有重复的人的姓名

select name
from A
where grade>60
group by name
having count(name)>1

一个人的时光

select name from A where grade>60 group by name having count(1)>1

renmihe

--创建表
create table aa(
name varchar2(10),
grade number(3)

);

--插入数据
insert into aa values('王五',56);
insert into aa values('张三',79);
insert into aa values('王五',68);
insert into aa values('张三',88);

insert into aa values('李四',95);

--查询成绩大于60，且姓名有重复的人的姓名
    select name
      from aa
    where grade>60
group by name
   having count(1)>1

马鹏磊

--查询出成绩大于60的人的姓名和成绩

select name,score from A where score  >'60'

 

//查询出不只一门成绩大于60分的人的姓名

select name
from A
where grade>60
group by name
having count(name)>1

 

//创建表

create table A (

 name varchar2(5),
 grade varchar2(4)
)

 

//向表中插入数据

insert into A values ('a','98')
insert into A values ('a','88');
insert into A values ('a','50');
insert into A values ('b','79');
insert into A values ('b','60');
insert into A values ('c','88');

 

//查询出成绩大于60分的，姓名有重复的人的姓名
//查询出不只一门成绩大于60分的人的姓名

select name
from A
where grade>60
group by name
having count(name)>1

--查询分数大于60的人的姓名和成绩
select name,grade from A where grade >'60'
--查询出不只一门成绩大于60分的人的姓名
--按姓名分组 having count(分组名称)>1
select name,grade from A where grade >'60'
group by name
having count(name)>1

 

zhangjialong

//创建表

create table A (

 name varchar2(5),
 grade varchar2(4)
)

//向表中插入数据

insert into A values ('a','98')
insert into A values ('a','88');
insert into A values ('a','50');
insert into A values ('b','79');
insert into A values ('b','60');
insert into A values ('c','88');

//查询出成绩大于60分的，姓名有重复的人的姓名

select name
from A
where grade>60
group by name
having count(name)>1

XIAOC

select name from A where score>60 group by A having conut(score)>1;

liufangyuan

--删除表
drop table A;
--创建表
create table  A(
   name varchar2(10),
   score number(3)
);
--提交
commit;
--插入数据
insert into A values('苏爱阳',89);
insert into A values('苏爱阳',99);
insert into A values('苏爱阳',58);
insert into A values('刘方园',89);
insert into A values('刘方园',52);
insert into A values('刘方园',32);
--提交
commit;
--查询出成绩大于60分的，姓名有重复的人的姓名
select name, count(name)
  from A
 where score > 60
 group by name
having(count(1) > 1)

Sarbr

delete from 表A where rowid not in(select min(rowid) from test group by 姓名,成绩);//先删除重复姓名

select * from 表A a where grade>60

Cracia

select name,count(1) from

(select * from A where score>60)

group by name having count(1)>1

杨柳

select * from A where score>60 group by name  having count(1)>1

梦紫菱0124

select * from Awhere group by name having count(1)>1 and score>60

FH

select name

from A

where score>60 and name not in(select name from A group by name having count(1)>1)

740317431

select  姓名 from  （select 姓名， count（1）  from A where 成绩>60 group by 姓名）t where t.count(1)>1;

abhan

select name
from A
where score>60 and name in(select name from A group by name having count(1)>1)

王之神判

select 姓名

from A

where 成绩>60

group by 姓名

having count(1)>1

sangpeng

select 姓名,count(1) from A where score>60 group by 姓名 and count>1

wulinan

select name 
from A
where score>60
group by name
having count(1)>1

hanqian

select name from a where score>60 group by name having count(1)>1

yanghao

SELECT E.SAL FROM EMP E,
(SELECT SAL,COUNT(SAL) C FROM EMP GROUP BY SAL)EE
WHERE EE.C>1 AND E.SAL=EE.SAL;

李莹莹

select  name from tabkeName group by name having count(1)>1

m1359292934

select name , count (*)  from a

where score >60

group by name having count(*)>1