Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Self join producing wrong results -SQL
create table #package_details (CID int,packet_id int, packet_status varchar(20),program_id int) insert into #package_details values (1001, 20, 'OPEN', 55), (1001, 21, 'OPEN', 23), (1001, 15, 'CLOSED', 54), (1001, 16, 'CLOSED', 23) create table #program (PID int,program varchar(20),parent_prog_id int, is_parent bit) insert into #program values ('23','PPROG',NULL,1), ('54','PROG1',23,0), ('55','PROG2',23,0) select pd.CID, pd.packet_id,pd2.packet_id,pd.packet_status from #package_details pd join #Program p on p.PID = pd.program_id join #package_details pd2 on pd.CID = pd2.CID and pd2.program_id=p.parent_prog_id --parent episode join #Program p2 on p2.PID=pd2.program_id
run
|
edit
|
history
|
help
0
string concatenation as aggregate operator in group by
repert
Transitive grouping with recursive sql
Window Functions - ROW_NUMBER()
Loan
QLCB_BTVN_TUAN 8
Jogarao1
1
Cine latino
Show slowest queries