sql数据重复查询问题

2014-06-03 09:26:19 280 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

深入解读ATPG Pattern类型：除了Basic Scan，Clock PO和RAM Sequential模式怎么用？本文深入解析ATPG高级Pattern类型，包括Clock PO和RAM Sequential模式的应用策略。通过Mentor DFT工具链中的Tessent平台，详细介绍了这些模式的工作原理、配置命令及实战案例，帮助提升芯片测试的故障覆盖率和效率。特别适用于处理时钟域交叉和嵌入式存储器的复杂电路测试需求。阅读详情

我想查询出一个表中不重复的数据，重复的取articleid 最大的，按照articleid 的倒叙排列，我是下面的写法，结果运行出来不对。
SELECT Publicaccounts,articleid FROM article GROUP BY Publicaccounts,articleid order by articleid desc

...全文

Python爬虫实战：逆向解析央视频加密参数（附完整代码）本文详细解析了央视频加密体系的技术实现，通过Python逆向工程实战演示如何解密动态密钥、AES加密和自定义哈希算法等核心组件。文章提供完整代码示例，涵盖GUID生成、参数构造和异步请求处理，帮助开发者掌握现代视频平台的反爬机制破解方法。阅读详情

a102470

MS-SQL Server 34,876 成员 254,635 内容

+ 关注 + 加入社区

切换为时间正序

a102470 2014-06-03

打赏
举报

引用 4 楼 fredrickhu 的回复:

试试：
select
 * 
from
  ( select *, ROW_NUMBER() over( order by AutoId,order by articleid desc ) row from article as s where 1=1  and not exists(select 1 from article where Publicaccounts=s.Publicaccounts and articleid>s.articleid)  ) t
where
  row between 1 and 20

加上count后该如何改呢？ select count(1) from article as t where 1=1 and not exists(select 1 from article where Publicaccounts=t.Publicaccounts and articleid>t.articleid) order by articleid desc ;

--小F-- 2014-06-03

打赏
举报

试试：
select
 * 
from
  ( select *, ROW_NUMBER() over( order by AutoId,order by articleid desc ) row from article as s where 1=1  and not exists(select 1 from article where Publicaccounts=s.Publicaccounts and articleid>s.articleid)  ) t
where
  row between 1 and 20

a102470 2014-06-03

打赏
举报

引用 2 楼 fredrickhu 的回复:

select * from article  as t where not exists(select 1 from article where Publicaccounts=t.Publicaccounts and articleid>t.articleid)  order by articleid desc

那个方法挺好用，但是我后来修改成这样了，报“除非另外还指定了 TOP 或 FOR XML，否则，ORDER BY 子句在视图、内联函数、派生表、子查询和公用表表达式中无效。”这个错误，请问该如何修改呀？ select * from ( select *, ROW_NUMBER() over( order by AutoId ) row from article as s where 1=1 and not exists(select 1 from article where Publicaccounts=s.Publicaccounts and articleid>s.articleid) order by articleid desc) t where row between 1 and 20

--小F-- 2014-06-03

打赏
举报

select * from article  as t where not exists(select 1 from article where Publicaccounts=t.Publicaccounts and articleid>t.articleid)  order by articleid desc

昵称90天可改一次 2014-06-03

打赏
举报


SELECT Publicaccounts,
		articleid=MAX(articleid)  
FROM article 
GROUP BY Publicaccounts 
order by articleid  desc

sql数据重复查询问题

相关推荐