| Author |
Message |
    
Symbol_of_king
Kurra Bewarse
Username: Symbol_of_king
Post Number: 1260
Registered: 12-2005
Posted From: 198.182.163.125
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, October 01, 2007 - 4:29 pm: |    |
select statename from table t1 where stateid=(select min(stateid) from table t1 where cond)
i dont think this is that simple....inka edo vundi vuntundi question ???? |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 5014
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, October 01, 2007 - 4:24 pm: | |
stateid select cheyyalsina avasaram ledu. kaani statename display cheyyali but statename ni min of stateid unnade kavali naku. |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 5013
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, October 01, 2007 - 4:23 pm: | |
statename and stateid rendu columns different untayi. migilina columsn anni same. ippudu stateid lo min unna row mathrame thesukovali, kani statename display cheyyali aa thesukunna stateid danidi. |
Symbol_of_king
Kurra Bewarse
Username: Symbol_of_king
Post Number: 1259
Registered: 12-2005
Posted From: 198.182.163.125
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, October 01, 2007 - 4:07 pm: | |
nuvvu specify chesina 2 values vunna column kakundaa query lo retrieve chesina migtha columns annitiloo...2 rows lo same values vunte nee work avuthundi ee query ani naa feeling |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 5012
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, October 01, 2007 - 4:05 pm: | |
work avvatam ledu mama  |
Symbol_of_king
Kurra Bewarse
Username: Symbol_of_king
Post Number: 1258
Registered: 12-2005
Posted From: 198.182.163.125
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, October 01, 2007 - 4:04 pm: | |
<<<<sel a, min(b) from t1 join t2 t1.x1 = t2.x2
group by a>>>>
deniki output hemu adiginattu vastundaa???
'b' tapithe migatha columns in all the rows equal aythe nee correct answer vastundi anukunta kada???? |
Pda
Celebrity Bewarse
Username: Pda
Post Number: 15420
Registered: 06-2006
Posted From: 129.138.18.85
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, October 01, 2007 - 3:42 pm: | |
Life is a game. So fight for survival and see if you're worth it. |
Vemana
Kurra Bewarse
Username: Vemana
Post Number: 1484
Registered: 12-2004
Posted From: 144.42.9.186
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, October 01, 2007 - 3:38 pm: | |
min (column_name) use cheyyi query lo. other columns ki group by add cheyyi like this
sel a, min(b) from t1 join t2 t1.x1 = t2.x2
group by a |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 5011
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, October 01, 2007 - 3:36 pm: | |
nenu oka query rasanu. andulo two rows vasthunnayi. oka column value 2 untunnayi. kani naaku aa column value min unna row nee ravali. el arayali condition?? |
