sql - LEFT JOIN FIlter -


if have 2 tables - table_a , table_b - , if using left join join them, how can filter rows table_b joined rows in table_a more once?
db flavor: teradata

if i'm not mistaken teradata supports window functions, might work:

select * (   select a.*,           b.*          count(*) on (partition a.mycol) cnt   table_a      left join table_b b on a.mycol = b.mycol    ... -- conditions ) t cnt > 1

(not tested)


Comments

Post a Comment

Popular posts from this blog

php - Extract Text from HTTP referer -

i using following code show referer link page on website. how can modify code shows part of link. i.e if website url www.example.com/?s=printing want extract printing. , should happen if format www.example.com/?s=aaa , not if format else www.example.com/printing. code: <?php session_start(); if ( !isset( $_session["origurl"] ) ) $_session["origurl"] = $_server["http_referer"]; echo $_session["origurl"] ?> i figured out , following code works: <?php session_start(); if ( !isset( $_session["origurl"] ) ) $_session["origurl"] = $_server["http_referer"]; $mysearchterm = $_server["http_referer"]; $whatiwant = substr($mysearchterm, strpos($mysearchterm, "=") +1); echo $whatiwant; ?>
Read more

Receive udp packets in android gstreamer -

i using eclipse juno in windows 7. doing programming on android 4.2 platform. want receive udp packets in gstreamer application. giving uri udp://127.0.0.1:1234 , sending file vlc player same computer. emulator giving message could not get/set setting from/on resource while in case of rtp, giving message no uri implementer found rtp ideas how receive streaming media in android?
Read more

Reversible shuffling a int array in java -

this question has answer here: reversible shuffle algorithm using key 4 answers i have int array of considerably large size. need shuffle array using key. should able obtain original array using same key. searched shuffle algorithms 1 found fisher yates not use key. the int array pixel values of image. need hide data it. hiding data after shuffling array enables accessing of data if 1 have key. fisher-yates uses pseudo-random number generator, can seed using key (look cryptographic prngs). reverse process, shuffle array of indices [0, n ) using same key, perform reverse shuffle.
Read more