用Partition by 分组查询的问题

[t101lian]

 select  * from  (
select ROW_NUMBER() over(  Partition by  name order by createTime) 
as num ,* from  [user] 
) a  where num =1

这是最开始的查询，现在想加一个条件，存在相同name的才取出第一条。比如里面只有一个叫张三的，
那这条数据就不查询出来。改怎么查？在线等

[卖水果的net]

在语法上看，不出现这样的情况，你提供一些测试数据出来；

[spiritofdragon]

select  * from  (
select 
ROW_NUMBER() over(  Partition by  name order by createTime) as num 
,count(1) over(  Partition by  name ) as cnt 
,* from  [user] 
) a  where num =1 and cnt >1

[t101lian]

引用 2 楼 spiritofdragon 的回复:

select  * from  (
select 
ROW_NUMBER() over(  Partition by  name order by createTime) as num 
,count(1) over(  Partition by  name ) as cnt 
,* from  [user] 
) a  where num =1 and cnt >1

count(1) over( Partition by ，， 学习了。 原来还可以这样用。