求一个sql语句的写法 select *from MyTab awhere day = (select min(day) from MyTab where name = a.name) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Select a.Name, a.Day, a.Count From MyTab a Join (select Name,Day=min(day) From MyTab)b On a.name=b.name and a.Day=b.Day Selct Name,Day,Count From Tab A inner join (Select Name,Min(Day) Day Group by Name) B On A.Name = B.Name And A.Day = B.Day Selct A.Name,A.Day,A.Count From Tab A inner join (Select Name,Min(Day) Day Group by Name) B On A.Name = B.Name And A.Day = B.Day 事务嵌套问题,回滚外层事务 很有挑战性的问题~~分不多了~!SQL高手多帮忙吧~~ 怎样查出结果位于数据库的行数,谢谢?? 怎么样复制多一个数据库? 字符串数字提取问题 求怎么设计表的一个列,不是主键,却有唯一值约束 sql问题 查询某一个时间段的SQL怎么写?精确到年月日时分秒 我的sql server开着,为什么连部上enterprise manager 里的data??? MSDE的安装条件? 请教一个分组问题,很有实用性 关于动态创建数据源 连接数据库 高手请进
From MyTab a Join
(select Name,Day=min(day) From MyTab)b On a.name=b.name and a.Day=b.Day
From Tab A inner join (Select Name,Min(Day) Day Group by Name) B
On A.Name = B.Name And A.Day = B.Day
From Tab A inner join (Select Name,Min(Day) Day Group by Name) B
On A.Name = B.Name And A.Day = B.Day