sql experts please come

[4Vikram]

i have a requirement like this..

Select AB, AC, AD, AE FROM Tbl.ABC 

Aite AD lo values are like Alabama, Alaska, Arkansas and so on..

I need to create a view which gets me results like 

IF AD = Alabama then 1 if AD = Alaska then 2 atla continuation and this will be like an added new column AF anukondi.. suggestions please and thanks

[sri_india]

2 minutes ago, 4Vikram said:

i have a requirement like this..

Select AB, AC, AD, AE FROM Tbl.ABC 

Aite AD lo values are like Alabama, Alaska, Arkansas and so on..

I need to create a view which gets me results like 

IF AD = Alabama then 1 if AD = Alaska then 2 atla continuation and this will be like an added new column AF anukondi.. suggestions please and thanks

I think it is not possible to do this bro .... req change cheyamani cheppu business ki 

[4Vikram]

3 minutes ago, sri_india said:

I think it is not possible to do this bro .... req change cheyamani cheppu business ki 

nijam cheptunavo serious cheptunavo ardam aitaledu man 

[mettastar]

case statement rasko

[kittaya]

3 minutes ago, mettastar said:

case statement rasko

+1 

[Picha lite]

3 minutes ago, mettastar said:

case statement rasko

[kittaya]

SELECT
   CASE 
    WHEN course_enrollment_settings.base_price = 0      THEN 1
    WHEN course_enrollment_settings.base_price>0 AND  
         course_enrollment_settings.base_price<=100     THEN 2
    WHEN course_enrollment_settings.base_price>100 AND   
         course_enrollment_settings.base_price<201      THEN 3
        ELSE 6
   END AS 'calc_base_price',
   course_enrollment_settings.base_price
FROM
    course_enrollment_settings
WHERE course_enrollment_settings.base_price = 0

apt example

[johnubhai_01]

case stmt raasuko.. 

 

[4Vikram]

2 minutes ago, kittaya said:

SELECT
   CASE 
    WHEN course_enrollment_settings.base_price = 0      THEN 1
    WHEN course_enrollment_settings.base_price>0 AND  
         course_enrollment_settings.base_price<=100     THEN 2
    WHEN course_enrollment_settings.base_price>100 AND   
         course_enrollment_settings.base_price<201      THEN 3
        ELSE 6
   END AS 'calc_base_price',
   course_enrollment_settings.base_price
FROM
    course_enrollment_settings
WHERE course_enrollment_settings.base_price = 0

apt example

bhaiyya problem endi ante 47 states unai motham 47 rayala ani?

[4Vikram]

8 minutes ago, mettastar said:

case statement rasko

 

4 minutes ago, kittaya said:

+1 

 

4 minutes ago, Picha lite said:

Just now, johnubhai_01 said:

case stmt raasuko.. 

 

andaru chepturu ani chepinav le 

[johnubhai_01]

Just now, 4Vikram said:

 

 

 

andaru chepturu ani chepinav le 

aa output ki kotthaga inkem chestham man..

 

[kittaya]

1 minute ago, 4Vikram said:

bhaiyya problem endi ante 47 states unai motham 47 rayala ani?

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

[mettastar]

Just now, johnubhai_01 said:

aa output ki kotthaga inkem chestham man..

 

decode 

[johnubhai_01]

1 minute ago, mettastar said:

decode 

RANK vadda

 

[ceelogreen]

4 minutes ago, 4Vikram said:

bhaiyya problem endi ante 47 states unai motham 47 rayala ani?

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