Select
*
From
Table11111 A
Where ID In (Select Min(ID) From Table11111 Group By name )
*
From
Table11111 A
Where ID In (Select Min(ID) From Table11111 Group By name )
解决方案 »
- EXCEL 服务器 注册机 怎么使用
- 作业,不会!~大家帮我好吗?
- sp4适用于任何版本SQLSERVER2000吗?
- 一个简单的SQL语句 不会写 谢谢了
- 如何在存储过程中循环插入记录?
- C++ 如何显示SQL数据库表中某一行某一列的值?
- 求sql语句解决方法!!!!!!!!
- 变一个数据库理所有表的相关列(varchar,nvarchar,char)的collate
- 从一个数据库 import数据 过来,为什么ID列的自动递增属性失效了?
- 无法打开登录所请求的数据库 "mysql"。登录失败。用户 'lesley' 登录失败。在线等!
- 一个sql问题,怎么做这个更新?
- sql触发器更新后及更新前比较的问题(想了几天了)
*
From
Table11111 A
Where ID = (Select Min(ID) From Table11111 Where name = A.name)
name,
type,
min(re)
from table11111
group by name,type
drop table tb
gocreate table tb(ID int,name varchar(10),type int,re varchar(10))
insert into tb(ID,name,type,re) values(3 , 'BB', 2, 'qq3')
insert into tb(ID,name,type,re) values(11, 'AA', 2, 'qq1')
insert into tb(ID,name,type,re) values(14, 'BB', 2, 'qq4')
insert into tb(ID,name,type,re) values(21, 'AA', 2 , 'qq2')select a.* from tb a,
(select name , min(id) id from tb group by name) b
where a.name = b.name and a.id = b.iddrop table tb
/*
ID name type re
----------- ---------- ----------- ----------
11 AA 2 qq1
3 BB 2 qq3(所影响的行数为 2 行)
*/
(ID Int,
name Varchar(10),
type Int,
re Varchar(100))
Insert Table11111 Select 3, 'BB', 2, 'qq3'
Union All Select 11, 'AA', 2, 'qq1'
Union All Select 14, 'BB', 2, 'qq4'
Union All Select 21, 'AA', 2, 'qq2'
GO
--方法一:
Select
*
From
Table11111 A
Where ID In (Select Min(ID) From Table11111 Group By name )--方法二:
Select
*
From
Table11111 A
Where ID = (Select Min(ID) From Table11111 Where name = A.name)--方法三:
Select
*
From Table11111 A
Where Not Exists(Select ID From Table11111 Where name = A.name And ID < A.ID)
--方法四:Select
A.*
From
Table11111 A
Inner Join
(Select MIn(ID) As ID, name From Table11111 Group By name) B
On A.ID = B.ID And A.name = B.name
GO
Drop Table Table11111
--Result
/*
ID name type re
3 BB 2 qq3
11 AA 2 qq1
*/