select orderid,customerid,orders.orderdate
from orders ,(select max(orderdate) orderdate from orders) a
where orders.orderdate =a.orderdate
from orders ,(select max(orderdate) orderdate from orders) a
where orders.orderdate =a.orderdate
解决方案 »
- 关于这两句SQL的执行效率
- 求一句SQL写法!
- 求一句SQL?
- |zyciis| 求一第SQL查询的操作方法 把值等于某个值的排在前面
- 在分区表MyTable中,怎么在第2个分区中查询所有数据
- 关于查询效率问题(高手进)
- 还是个简单的问题,知道的话一下就搞定了!!!!有关时间的!
- 今天全是数据库的问题,这个我最菜了,再请教!
- c/s型sql server程序如何多终端同时录入一个表,但是表中的编号字段的值不重复
- WIN98上的SQL Server能注册NT服务器的上SQL Server,而NT服务器的上SQL Server却不能注册WIN98上的SQL Server?
- 数据库语言中写文件时,我想写入特殊符号&和#这些怎么写呢
- 一个有关查询的简单问题,请教!
from orders a
where exists(select max(orderdate)
from orders having max(orderdate) =a.orderdate)
from orders a inner join (select max(orderdate) orderdate from orders) b
on a.orderdate =b.orderdate
from orders a inner join (select max(orderdate) orderdate from orders) b
on a.orderdate =b.orderdate
go
select orderid,customerid,orderdate
from orders
where orderdate in (select max(orderdate)
from orders)
go
select top 1 orderid,customerid,orderdate from orders order by orderdate desc