select * from (select top 999999999 * from news order by input_date desc) middata order by type;
select * from (select top 999999999 * from news order by type) middata order by input_date desc;
select * from (select top 999999999 * from news order by type) middata order by input_date desc;
解决方案 »
- SQL Server 2000客户要求一个表里面的内容不能让上级部门看到具体的内容!
- 这个更新怎么写?
- 2个时间字段的差值问题?
- SQL Server2000,数据update后,修改后的数据全部消失
- 两个结构相同的表如何整合成一个表呢?
- 请教成本调整的问题
- 求助:真心的希望大家能帮助我,谢谢您们了。
- 最近得到一个Microsoft Project Server 2002试用版,在安装时提示使用SQLSERVER用户创建数据库,输入用户名和密码后总是提示没有SECURITY
- OUTPUT怎么样处理NTEXT数据类型
- SQLServer2000 标准版15 user 1.6万,企业版25 user 8万,这是我得到的报价 不会吧?
- mssql分页查询有什么常用的办法吗
- 如何把一个表里面的内容倒个?
select * from news order by type,input_date desc;
GO
select * from news order by type,input_date desc
GO
命令已成功完成。
Other answers are all incorrect absolutely.
thanks for replying, mates.
Any other guru here?
select * from (select * from news order by input_date desc) middata order by type;
select * from (select * from news order by type) middata order by input_date desc;try:
select * from news order by type,input_date desc