Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Combined Where and having
create table #TempAccount (UserId int, ACID int) insert into #TempAccount values (100, 1), (100, 2), (100, 3), (100, 4), (101, 2), (102, 1), (103, 2), (103, 3), (103, 4) select * from #TempAccount Select USERID,ACID, ROW_NUMBER() over(partition by USERID order by USERID ) as rownumber into #abc from #TempAccount --WHERE rownumber < = 2 and ACID in (2,3) SELECT *,ROW_NUMBER() over(partition by USERID order by USERID ) as rownumber FROM #abc where ACID in (2,3) and having count(rownumber) >=2 --select ACID from #abc where ACID in (2,3) group by ACID HAVING COUNT(ACID) = 2 drop table #TempAccount
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
Combined Where and having
group for team members and winners in sql-server
Trabalho.Agrecação
Train Reservation
Return a single column that matches a parameter
student
Q2_15min
cms by valli
CREATE DATABASE
Get all dates between two given dates
Please log in to post a comment.