UC知道谁能写出来这条SQL语句给他100分
来源：百度知道 编辑：UC知道 时间：2024/05/30 08:04:59
已知表:
create table TEST_A
(
ID int not null,
CODE VARCHAR(8) not null,
NAME VARCHAR(10),
AGE int,
ADDRESS VARCHAR(100)
)
insert into TEST_A (ID, CODE, NAME, AGE, ADDRESS)
values (1, '10000001', '一', 25, '大连');
insert into TEST_A (ID, CODE, NAME, AGE, ADDRESS)
values (2, '10000002', '二', 25, '北京');
insert into TEST_A (ID, CODE, NAME, AGE, ADDRESS)
values (3, '10000003', '三', 30, '上海');
insert into TEST_A (ID, CODE, NAME, AGE, ADDRESS)
values (4, '10000004', '四', 30, '广州');
insert into TEST_A (ID, CODE, NAME, AGE, ADDRESS)
values (5, '10000005', '五', 50, '长春');
insert into TEST_A (ID, CODE, NAME, AGE, ADDRESS)
values (1, '10000006', '六', 60, '大连');
insert into TEST_A (ID, CODE, NAME, AGE, ADDRESS)
values (2,
create table TEST_A
(
ID int not null,
CODE VARCHAR(8) not null,
NAME VARCHAR(10),
AGE int,
ADDRESS VARCHAR(100)
)
insert into TEST_A (ID, CODE, NAME, AGE, ADDRESS)
values (1, '10000001', '一', 25, '大连');
insert into TEST_A (ID, CODE, NAME, AGE, ADDRESS)
values (2, '10000002', '二', 25, '北京');
insert into TEST_A (ID, CODE, NAME, AGE, ADDRESS)
values (3, '10000003', '三', 30, '上海');
insert into TEST_A (ID, CODE, NAME, AGE, ADDRESS)
values (4, '10000004', '四', 30, '广州');
insert into TEST_A (ID, CODE, NAME, AGE, ADDRESS)
values (5, '10000005', '五', 50, '长春');
insert into TEST_A (ID, CODE, NAME, AGE, ADDRESS)
values (1, '10000006', '六', 60, '大连');
insert into TEST_A (ID, CODE, NAME, AGE, ADDRESS)
values (2,
select a.* ,(select count(*) from test_a b where a.id=b.id) as 同id人数,(select count(*) from test_a c where a.age=c.age) as 同年龄人数 from test_a a
用企业管理器自己加吧
企业管理器可以设计表的．
你进去看看就知道了．．．
select * ,
(select count(*) from test_a where id=a.id) as countid,
(select count(*) from test_a where age=a.age) as countage
from test_a a