Pl/sql Doubt

[kedharinath]

with cte as

(

select colA,colB,row_number() over(partition by colA) as rid

)

update cte set colA = colB where rid = 1;

[kedharinath]

2 diff tbls ante join cheyyalevaa two tbls ni?? no comon col a??

ne rotta..em sesavo nekaina ardam aindha..

[kedharinath]

Column A        Column B

 

1                          55

1                          45

1                          79

1                          64

1                          89

2                          23

2                          87

3                          45

4                          123

4                          111

4                          65

5                           72

5                          31

5                          18

5                          05

 

Ila unnai bro.. so 1st should be replaced to 55

 

1- 55

2-23

3-45

4-123

 

chepandi bhayya koncham ippudu

 

 

 

with cte as

(

select colA,colB,row_number() over(partition by colA) as rid

)

update cte set colA = colB where rid = 1;

 

[mtkr]

ne rotta..em sesavo nekaina ardam aindha..

ardam kaakaponiki emundhii...
nen joins esina... Nuv cte esinavv...
anthe gaa...

[mtkr]

with cte as
(
select colA,colB,row_number() over(partition by colA) as rid
)
update cte set colA = colB where rid = 1;

row num la order by eadii???

[kedharinath]

ardam kaakaponiki emundhii...
nen joins esina... Nuv cte esinavv...
anthe gaa...

goti tho poyedhaniki goddali dhaka y ani..

[kedharinath]

row num la order by eadii???

his req is to grab the first record..not the asc or desc of colB..date criteria petkundo or vere attributes tho 10ginchkuntado teldh ga..andhke petle..

[mtkr]

goti tho poyedhaniki goddali dhaka y ani..

akkada goddali kuda saripodu anta... cranes neededd...

[mtkr]

his req is to grab the first record..not the asc or desc of colB..date criteria petkundo or vere attributes tho 10ginchkuntado teldh ga..andhke petle..

assal em pettakapothe 10gichukodaaniki kuda padiki raad gaa

[kedharinath]

akkada goddali kuda saripodu anta... cranes neededd...

ekada petkuntadanta cranes..

[kedharinath]

assal em pettakapothe 10gichukodaaniki kuda padiki raad gaa

emi pettanavsram le..req batti change seskovale..

[sanbk]

emi pettanavsram le..req batti change seskovale..

 

PM chesa koncham chudu

[loveindia]

row num la order by eadii???

 

sorry reverse lo cheppa... edited....

[pachimirchi]

RowNumber() lo order by is not compulsory man... its just something you can add if you want ordered list of data. 

 

rownumber in tsql ki order by vundali bro partition by optional .. rownum in oracle sql is a pseudo column..
 

[loveindia]

rownumber in tsql ki order by vundali bro partition by optional .. rownum in oracle sql is a pseudo column..
 

 

partition by anukoni aavesham lo esaaa man post... andukey edit chesaa... india nunchi ee rathri poota work chestuntey vachina sql kuda marchipoyettu unna...