Rosebud
Rosebud

Reputation: 589

CTE row_number partition row rank using temp table

insert into #TempUserTable  

query

;with cte as  
(  
select *,row_number() over(partition by (userid) order by login_time) as   'rowrank'  
from #TempUserTable  
)  

getting error incorrect syntax near ')'

Upvotes: 0

Views: 8453

Answers (2)

D'Arcy Rittich
D'Arcy Rittich

Reputation: 171599

The syntax looks fine, just add your select at the end.

;with cte as
(
    select *,row_number() over(partition by (userid) order by login_time) as 'rowrank'
    from #TempUserTable
)
select * 
from cte 
where rowrank = 1

Upvotes: 2

dfundako
dfundako

Reputation: 8324

;with cte as
(
select *,row_number() over(partition by (userid) order by login_time) as 'rowrank'
from TempUserTable
)
SELECT * 
INTO #tempusertable
FROM cte

Upvotes: 1

Related Questions