ORACLE SQL How to implement a UNION clause but maintain the order of each SELECT -

-

using union clause in 2 select statements how can guarantee order of execution? example:

select a.poclcdde, a.poclnpol, a.poclcdcl   dtpocl      a.poclcdcl in (216450,                           562223,                           250056,                           202153,                           8078)        , poclcdce = 0        , pocltpsg = '01' union select a.poclcdde, a.poclnpol, a.poclcdcl   dtpocl      a.poclcdcl in (216450,                           562223,                           250056,                           202153,                           8078)        , pocltpsg = '02'   poclcdde   poclnpol   poclcdcl ---------- ---------- ----------        100    1000001     202153        100    5001021     216450        100    9000386       8078        100    9900633     250056        100    9900634     250056        100    9901720     562223        100    9901763     562223        200    1000001     202153        200    5001021     216450

in case, how can guarantee first records query1 , rest query2. use poclcdcl column (or virtual column) , order that, in case need distinct rows.

  select *     (select a.poclcdde,                  a.poclnpol,                  a.poclcdcl,                  1 type             dtpocl                a.poclcdcl in (216450,                                     562223,                                     250056,                                     202153,                                     8078)                  , poclcdce = 0                  , pocltpsg = '01'           union           select a.poclcdde,                  a.poclnpol,                  a.poclcdcl,                  2 type             dtpocl                a.poclcdcl in (216450,                                     562223,                                     250056,                                     202153,                                     8078)                  , pocltpsg = '02') order type     poclcdde   poclnpol   poclcdcl       type ---------- ---------- ---------- ----------        200    1000001     202153          1        100    1000001     202153          1        100    9000386       8078          1        100    9900634     250056          2        100    9901720     562223          2        100    9901763     562223          2        200    5001021     216450          2        100    9000386       8078          2        100    5001021     216450          2        100    9900633     250056          2

i need interact each row order: first query prevails. thanks

you can use union all type "virtual" column right order, , use filter on returned value of row_number analytic function remove duplicates while prioritizing first query's rows:

with cte (           select a.poclcdde,                  a.poclnpol,                  a.poclcdcl,                  1 type             dtpocl                a.poclcdcl in (216450,                                     562223,                                     250056,                                     202153,                                     8078)                  , poclcdce = 0                  , pocltpsg = '01'           union           select a.poclcdde,                  a.poclnpol,                  a.poclcdcl,                  2 type             dtpocl                a.poclcdcl in (216450,                                     562223,                                     250056,                                     202153,                                     8078)                  , pocltpsg = '02' ) select poclcdde, poclnpol, poclcdcl   (select t.*,                row_number() on (                  partition t.poclcdde, t.poclnpol, t.poclcdcl                      order t.type) rn           cte t)  rn = 1  order type

Comments

Post a Comment

Popular posts from this blog

Spring Boot + JPA + Hibernate: Unable to locate persister -

-
i trying work entity inside request method of spring boot application. entity in project , pom.xml has dependencies it. why error message?: org.hibernate.unknownentitytypeexception: unable locate persister: com.ric.bill.model.bs.par package com.ric.web; import java.util.concurrent.atomic.atomiclong; import javax.persistence.entitymanager; import javax.persistence.persistencecontext; import net.sf.ehcache.cachemanager; import net.sf.ehcache.management.cache; import net.sf.ehcache.management.cachestatistics; import org.hibernate.stat.statistics; import org.springframework.beans.factory.annotation.autowired; import org.springframework.boot.autoconfigure.domain.entityscan; import org.springframework.cache.annotation.enablecaching; import org.springframework.transaction.annotation.enabletransactionmanagement; import org.springframework.transaction.annotation.propagation; import org.springframework.transaction.annotation.transactional; import org.springframework.web.bind.annotati
Read more

go - Golang: panic: runtime error: invalid memory address or nil pointer dereference using bufio.Scanner -

-
i implementing go program uses bufio.scanner , bufio.writer have packaged code follows package main import ( "fmt" "player/command" "strings" ) func main() { //enter code here. read input stdin. print output stdout commands.scanner.scan() { //scan new line , send comand variable check command exist or not input := strings.split(strings.trim(commands.scanner.text(), " "), " ") command := input[0] if command == "" { fmt.printf("$ %s:", commands.pwd) continue } if !commands.commands[command] { commands.throwerror("cannot recognize input.") } else { commands.execute(command, input[1:], nil) } fmt.printf("$ %s:", commands.pwd) } } i using init.go file in main package follows package main import ( "flag" "player/sourc
Read more

c - double free or corruption (fasttop) -

-
this code reads null terminated string file (file containing null terminated strings & should provide index wanted string). error: *** error in `./main': double free or corruption (fasttop): 0x090a4a80 *** aborted code: char *tmp_realloc=null; char *sstring=null; int i=1; /*set file pointer point string*/ fseek(fh,index,seek_set); sstring=(char*)malloc(sizeof(char)); if(sstring == null) return null; tmp_realloc=sstring; while( (*(sstring+i-1)=(char)fgetc((file*)fh)) != 0x0 ) { /*reallocate more memory*/ tmp_realloc=(char*)realloc((char*)sstring,++i); /*if not same address copy old new & set old point new*/ if(tmp_realloc != sstring){ strcpy((char*)tmp_realloc,(char*)sstring); free(sstring); sstring=tmp_realloc; } } could tell me pointer causing issue (& reason) ? remove part /*if not same address copy old new & set old point new*/ if(tmp_realloc != sstring){ strc
Read more