sql experts please come

[kittaya]

4 minutes ago, mettastar said:

decode 

 

[4Vikram]

4 minutes ago, kittaya said:

function rasi danini call chesuko statement lo ... rayali mari aekkado oka chota thappadhu

will check thanks

1 minute ago, ceelogreen said:

oka table la 47 entries eskoni  aa table ni nee query lo join sesko...

nice thanks 

[4Vikram]

5 minutes ago, johnubhai_01 said:

aa output ki kotthaga inkem chestham man..

 

nasty vuncle

[mettastar]

select

A.state,

NVL(B.RNK,'SOMEDEFAULT') 

from table A

left join (select distinct state, dense_rank() (order by state) rnk from table) B

on A.STATE=B.STATE

 

 

This works if you are numbering the states in sequential order

[mettastar]

5 minutes ago, johnubhai_01 said:

RANK vadda

 

rank kuda raasa vuncle 

[johnubhai_01]

3 minutes ago, mettastar said:

rank kuda raasa vuncle 

nenu ade iddamanukunna but varchar ki ranking ivvaru kada ani post cheyaled.

[4Vikram]

8 minutes ago, mettastar said:

select

A.state,

NVL(B.RNK,'SOMEDEFAULT') 

from table A

left join (select distinct state, dense_rank() (order by state) rnk from table) B

on A.STATE=B.STATE

 

 

This works if you are numbering the states in sequential order

this would be perfect but ipude susna aa table la states names tho paatu inka chaala unai like  numbers and some other values also 

[kick_seenu]

select var = ROW_NUMBER() over (partition by AD order by AD) from your table

[allu_potato]

we can do in Java eclipse

[Manikyam]

1 hour ago, 4Vikram said:

this would be perfect but ipude susna aa table la states names tho paatu inka chaala unai like  numbers and some other values also 

still tat works

[4Vikram]

6 minutes ago, kick_seenu said:

select var = ROW_NUMBER() over (partition by AD order by AD) from your table

this works if I have only states man but akada aa table lo inka vere values kuda unai so idhi not working.. paina mettastar vuncle chepindi working

[Manikyam]

Just now, 4Vikram said:

this works if I have only states man but akada aa table lo inka vere values kuda unai so idhi not working.. paina mettastar vuncle chepindi working

select only state field

[4Vikram]

13 minutes ago, Manikyam said:

select only state field

yeah cheyochu but county ani inko column kuda undi adi kuda kavale anduke not working

[ranku_mogudu]

mettastar ichina ref table with rank is the best way to do, migatha values as per state untey add chesuko 

[JollyBoy]

19 minutes ago, 4Vikram said:

yeah cheyochu but county ani inko column kuda undi adi kuda kavale anduke not working

nuv rasina query ikada vey.. sample columns and update column