问个数据库查询问题 我想问下, 我有个STU的表, 我想按ID 倒叙输出这个表, 但是这个表的最后一个我又想排除掉不输出, 这个语句怎么实现呢 ?就是例如字段ID: 1 2 3 4 5 6 我想倒叙输出: 5 4 3 2 1 而6这个字段的数据就不输出了 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from t where ID<>6 order by ID desc select * from stuwhere id<>0order by id desc select * from t where ID <6 order by ID desc declare @n intSELECT @n=COUNT(id) - 1 FROM stuexec('select * from (SELECT TOP '+ @n+' * FROM stu) a order by id desc') select * from t where ID <6 order by ID desc SELECT * FROM stuWHERE id <> (SELECT max(id) FROM stu) ORDER BY id DESC这样也是可以的,只是有一个子查询~! SELECT * FROM stuWHERE id <> (SELECT top 1 id FROM stu order by id desc) ORDER BY id DESC SELECT * FROM stuWHERE id not in (SELECT max(id) FROM stu) ORDER BY id DESC 动态SQL的问题,已经搞了两天了 两个表的关联查询问题,请高人指点! 晕.怎么做呀. ???急!~在线等~~高手的语句~~~50分 如何使用sql语句将表的列名aa改为bb? 谁写过存储过程--将本地数据库恢复到remote 上? 很菜:何谓B/S结构?有哪里找到详细的资料? 一个关于用SQL写的BOM展开的递归存储过程,为什么只能到32层是微软的问题还是我的问题? 这个问题让我茶饭不思。 如何处理三维表的关系???建ado对象占系统资源大么? 游标问题 sdsdf
select * from stu
where id<>0
order by id desc
declare @n int
SELECT @n=COUNT(id) - 1 FROM stu
exec('select * from (SELECT TOP '+ @n+' * FROM stu) a order by id desc')
SELECT *
FROM stu
WHERE id <> (SELECT max(id) FROM stu)
ORDER BY id DESC这样也是可以的,只是有一个子查询~!
FROM stu
WHERE id <> (SELECT top 1 id FROM stu order by id desc)
ORDER BY id DESC
FROM stu
WHERE id not in (SELECT max(id) FROM stu)
ORDER BY id DESC