Sql Exfarts Ravali

[nenu_devudni]

select siken,
       mutton,
       keema,
       MIN(goat_curry)
  from (select siken,
               mutton,
               keema,
      CASE WHEN goat = 'Average' then 1
           when goat = 'Tasty' then 2
           when goat = 'Bokkalaundi' then 3
      END goat_curry
       from biskit,cream_biskit, salt_bisket
      where blah = blah
        and bluh = bluh)
     group by siken,
                   mutton,
                   keema;

 

 

esonti query run sesse .. oke record ravali nak matram rendu ossunay .. fix etla seyal seppandi kasta ..

 

 

 

 

[dotnetrockz]

use grouoby and having ti filter the dup

[kirs149]

emindi mayya neeku

 

[nenu_devudni]

use grouoby and having ti filter the dup

groupby sesinay kada nen mari enduku ratle .. . bye1

[mettastar]

 siken,
       mutton,
       keema,

 

veetillo two groups unnayemo... okati halal inkoti non halal

[nenu_devudni]

 siken,
       mutton,
       keema,

 

veetillo two groups unnayemo... okati halal inkoti non halal

 

atla kad vuncle .. mixi so esi joins pettina aina rendu ossunay naku .. em seyal samaj aitale

[andhravodu]

select siken,
       mutton,
       keema,
       MIN(goat_curry)
  from (select siken,
               mutton,
               keema,
      CASE WHEN goat = 'Average' then 1
           when goat = 'Tasty' then 2
           when goat = 'Bokkalaundi' then 3
      END goat_curry
       from biskit,cream_biskit, salt_bisket
      where blah = blah
        and bluh = bluh)
     group by siken,
                   mutton,
                   keema;

 

 

esonti query run sesse .. oke record ravali nak matram rendu ossunay .. fix etla seyal seppandi kasta ..

 

 

MIN vadite 2 vastunnayi ante, you're getting 2 same values dude. hack solution: inner select lo distinct padeyyi. performance slow avuddi kani, work avuddi

[samajaaragamana]

uncle ela unnav

 

[nenu_devudni]

MIN vadite 2 vastunnayi ante, you're getting 2 same values dude. hack solution: inner select lo distinct padeyyi. performance slow avuddi kani, work avuddi

esina pedaga theda ledu vuncle .. nen test sese daniki 2 records unay .. goat = 'Average' and goat = 'Tasty' .. Tasty goat okate raval .. but Average di kuda ostundi hain bye1

[nenu_devudni]

uncle ela unnav

bagane una vuncle .. nu etla unay bye1

[mettastar]

itla vasthunnaya results ?

A,B,C, 1

A,B,C, 2

 

or

 

A,B,C, 1

A,B,D, 2 ??

[samajaaragamana]

bagane una vuncle .. nu etla unay bye1

bane unai.........sala rojulaki achinav monna oka help kavalsi ochindi.................

[nenu_devudni]

itla vasthunnaya results ?

A,B,C, 1

A,B,C, 2

 

or

 

A,B,C, 1

A,B,D, 2 ??

 

uhu atla ratle .. .2 distinct records ostunay hain ... Tasty goat ki okati .. Average goat di okat ...

 

A,B,C,1

D,E,F, 2

[andhravodu]

esina pedaga theda ledu vuncle .. nen test sese daniki 2 records unay .. goat = 'Average' and goat = 'Tasty' .. Tasty goat okate raval .. but Average di kuda ostundi hain bye1

Ok. correct gane undi

 

silk1, mutton1, keema1, 1

silk2, mutton2, keema2, 2

 

ee 2 vachinapudu, you're getting both outside, silk1 okkate kavali antunnavu. Oracle lo least ane function undi. sql server lo ala unte, adi teesukoni cheyi

[nenu_devudni]

bane unai.........sala rojulaki achinav monna oka help kavalsi ochindi.................

le roju eda ne unay ... kani musugu lo tirugutunay .. bye1 upto date post lu kuda sustunay .. nevi sana funny ga post lu unay ... em kaval ee neku seppe sesdam