sql字符串问题 求一条语句:若name前五个字符相同,只取val最小的一条name valaaaaabb 11aaaaacc 12AAAAABB 10AAAAACC 9返回name valaaaaabb 11AAAAACC 9 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select name,min(val) from Table group by left(name,5) 表中字段不只含有name 和 val,还有很多别的字段。用group by 不行吧 select * from Table t where not exists (select 1 from table where t.name=name,t.val>val) 若name valaab 12aab 13则返回name valaab 12意思是字符长度不超过5的时候也要包括在内 select * from tb t where not exists(select 1 from tb where name=t.name and val<t.val) SELECT * FROM TB T WHERE VAL=SELECT (min(val) from TB left(name,5)=left(T.name,5)) select * from Table t where not exists (select 1 from table where t.name=name and t.val>val) select * from tb twhere not exists(select * from tb where left(name,5)=left(t.name,5) and val<t.val) select * from Table t where not exists (select 1 from table where left(t.name,5)=left(name,5) and t.val>val) select * from tb t where not exists(select 1 from tb where left(name,5)=left(t.name,5) and val<t.val) SELECT * FROM TB T WHERE VAL=(SELECT min(val) from TB left(name,5)=left(T.name,5)) select * from Table t where not exists (select 1 from table where left(name,5)=left(t.name,5),t.val>val) SELECT * FROM TB T WHERE VAL=(SELECT min(val) from TB name=T.name)?就这样 windowsxp下如何配置sql server 2000的C/S模式? T-SQL语句中..是神马意思? SQL2008能实现远程同步复制技术吗? ODBC和OLEDB 100分求助!!!怎样用SQL发MAIL时在邮件内容中加入查询结果表格????? 好久没摸了-----一个简单的计算问题 求一条查询语句 一个表和两个表问题 85分给你 如何把1台SQL SERVER7的库,导入到另一台SQL SERVER中,而且2台SERVER不互连 如何判断调用的存储过程是否返回了结果集? 关于hmtl表单元素在数据库中存储
name val
aab 12
aab 13则返回
name val
aab 12意思是字符长度不超过5的时候也要包括在内
select * from tb t
where not exists(select * from tb where left(name,5)=left(t.name,5) and val<t.val)
*
from
tb t
where
not exists(select 1 from tb where left(name,5)=left(t.name,5) and val<t.val)
select * from Table t where not exists (select 1 from table where left(name,5)=left(t.name,5),t.val>val)
就这样