求一sql语句~马上给分~~在线等! select id,max(tableindex),tablenumber,starttime from t_orderdish group by id,tableindex,tablenumber,starttime having tablenumber=1 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from t_orderdish where tableindex=(select max(tableindex) from t_orderdish where tablenumber=1) Select * from t_orderdish where tablenumber = 1 and tableindex = (select max(tableindex) from t_orderdish where tablenumber=1) select * from t_orderdish where tableindex =(select max(tableindex) from t_orderdish where tablenumber=1) select * from t_orderdish A where tablenumber=1 andtableindex = (select max(tableindex) from t_orderdish where tablenumber=1) select * from t_orderdish where tablenumber=1 and tableindex=max(tableindex) select * from t_orderdish where tablenumber=1 and tableindex=(select max(tableindex) from t_orderdish where tablenumber=1) select * from t_orderdishwhere tableindex in(select max(tableindex) from t_orderdish where tablenumber=1) select * from t_orderdish where tablenumber=1 and tableindex=(select max(tableindex) from t_orderdish where tablenumber=1) 查询问题 向各位高手求这样的Sql语句 抢分就是这么简单。 sql server 2005镜像无法访问或不存在。请检查网络地址名称,并检查本地和远程端点 100分求教order by 子句? 字符串长度问题! SQL行转列 不同 Name 的Database可以有相同的File Name,奇怪。 向高手请教SQL Server 2000在Weblogic7下的配置?? 请教关于 SQLServer的CREATE TABLE 的一点小问题??? 已经有一表communication , 我要把它改名为comm 请我怎么找出表中一个字段A中含有小写英文的记录!
select max(tableindex) from t_orderdish where tablenumber=1)
tableindex = (select max(tableindex) from t_orderdish where tablenumber=1)
where tablenumber=1 and tableindex=max(tableindex)
from t_orderdish
where tableindex in(
select max(tableindex) from t_orderdish where tablenumber=1)