Group By Use Chesi Elaaa

[rapchik]

[quote name='arey ooo samba' timestamp='1343253591' post='1302200372']
yes..I need col1 also baa




col2 aggregation ante...col2 lo "abc" 2 times repeat ayyindi kada baa entire table loo...so col3 lo value 2 ani ravali for row1 and row3 but for row2 lo "xyz" ani oka sare undi kada overall table loo andhukee col3 lo dani value 1 ani ravali

I am dng it in DB2 baa
[/quote]

SELECT dbo.TableA.FieldA, max(dbo.TableB.FieldA) As Expr1
FROM dbo.TableA INNER JOIN dbo.TableB ON dbo.TableA.SomeID = dbo.TableB.SomeID
Group by dbo.TableA.FieldA

??

[rapchik]

SELECT distinct * FROM table_a as a, table_b as b, table_c as group by a.name ORDER BY a.id ASC

[kiss4amiss]

paina chandrabhai6 cheppinattu,


SQL> select * from test;

COL1 COL2
---------- ----------
1 abc
2 xyz
3 abc


SQL> [color="blue"]SELECT[/color][color=#000000] [/color][color="maroon"]col1[/color][color="silver"],[/color][color=#000000] [/color][color=#000000] [/color][color="maroon"]col2[/color][color="silver"],[/color][color=#000000] [/color]
[color=#000000] [/color][color="maroon"]([/color][color="blue"]SELECT[/color][color=#000000] [/color][color="fuchsia"][i]Count[/i][/color][color="maroon"]([/color][color="maroon"]col2[/color][color="maroon"])[/color][color=#000000] [/color]
[color=#000000] [/color][color="blue"]FROM[/color][color=#000000] [/color][color="maroon"]test[/color][color=#000000] [/color][color="maroon"]a[/color][color=#000000] [/color]
[color=#000000] [/color][color="blue"]WHERE[/color][color=#000000] [/color][color="maroon"]a[/color][color="silver"].[/color][color="maroon"]col2[/color][color=#000000] [/color][color="silver"]=[/color][color=#000000] [/color][color="maroon"]b[/color][color="silver"].[/color][color="maroon"]col2[/color][color=#000000] [/color]
[color=#000000] [/color][color="blue"]GROUP[/color][color=#000000] [/color][color="blue"]BY[/color][color=#000000] [/color][color="maroon"]a[/color][color="silver"].[/color][color="maroon"]col2[/color][color="maroon"])[/color][color=#000000] [/color][color="blue"]AS[/color][color=#000000] [/color][color="maroon"]col3[/color][color=#000000] [/color]
[color="blue"]FROM[/color][color=#000000] [/color][color="maroon"]test[/color][color=#000000] [/color][color="maroon"]b[/color][color="silver"];[/color]

COL1 COL2 COL3
---------- ---------- ----------
1 abc 2
2 xyz 1
3 abc 2

[chandrabhai6]

[quote name='kiss4amiss' timestamp='1343253879' post='1302200402']
paina chandrabhai6 cheppinattu,


SQL> select * from test;

COL1 COL2
---------- ----------
1 abc
2 xyz
3 abc


SQL> [color="blue"]SELECT[/color][color=#000000] [/color][color="maroon"]col1[/color][color="silver"],[/color][color=#000000] [/color][color=#000000] [/color][color="maroon"]col2[/color][color="silver"],[/color][color=#000000] [/color]
[color=#000000] [/color][color="maroon"]([/color][color="blue"]SELECT[/color][color=#000000] [/color][color="fuchsia"][i]Count[/i][/color][color="maroon"]([/color][color="maroon"]col2[/color][color="maroon"])[/color][color=#000000] [/color]
[color=#000000] [/color][color="blue"]FROM[/color][color=#000000] [/color][color="maroon"]test[/color][color=#000000] [/color][color="maroon"]a[/color][color=#000000] [/color]
[color=#000000] [/color][color="blue"]WHERE[/color][color=#000000] [/color][color="maroon"]a[/color][color="silver"].[/color][color="maroon"]col2[/color][color=#000000] [/color][color="silver"]=[/color][color=#000000] [/color][color="maroon"]b[/color][color="silver"].[/color][color="maroon"]col2[/color][color=#000000] [/color]
[color=#000000] [/color][color="blue"]GROUP[/color][color=#000000] [/color][color="blue"]BY[/color][color=#000000] [/color][color="maroon"]a[/color][color="silver"].[/color][color="maroon"]col2[/color][color="maroon"])[/color][color=#000000] [/color][color="blue"]AS[/color][color=#000000] [/color][color="maroon"]col3[/color][color=#000000] [/color]
[color="blue"]FROM[/color][color=#000000] [/color][color="maroon"]test[/color][color=#000000] [/color][color="maroon"]b[/color][color="silver"];[/color]

COL1 COL2 COL3
---------- ---------- ----------
1 abc 2
2 xyz 1
3 abc 2
[/quote]

[qwerty1204]

[quote name='jaffanajeffada' timestamp='1343253499' post='1302200354']
nenu ichina SQL oka sari try chey baa, work avvudhi ani anukuntunna
[/quote]

daniki syntax error vasthundi baa...

[innovative]

[img]http://s10.postimage.org/85jm6lh61/image.png[/img]

[chandrabhai6]

[quote name='innovative' timestamp='1343254105' post='1302200426']
[img]http://s10.postimage.org/85jm6lh61/image.png[/img]
[/quote]

Repost

[kiraaaak]

select col1
,col2
,count(col2) over (partition by col2) col3
from xyz


analytical function ba .. idi try chey ... TOAD ledu nagara .. execute cheddam ante

[chandrabhai6]

[quote name='kiraaaak' timestamp='1343254283' post='1302200447']
select col1
,col2
,count(col2) over (partition by col2) col3
from xyz


analytical function ba .. idi try chey ... TOAD ledu nagara .. execute cheddam ante
[/quote]
Bayya he is saying db2 so not sure analytic functions are supported

[ChampakDas]

endhi intha complicated ga rastunnaru..

[ChampakDas]

ohh yeah I was thinking in the similar lines..
[quote name='kiraaaak' timestamp='1343254283' post='1302200447']
select col1
,col2
,count(col2) over (partition by col2) col3
from xyz


analytical function ba .. idi try chey ... TOAD ledu nagara .. execute cheddam ante
[/quote]

[qwerty1204]

[quote name='kiss4amiss' timestamp='1343253879' post='1302200402']
paina chandrabhai6 cheppinattu,


SQL> select * from test;

COL1 COL2
---------- ----------
1 abc
2 xyz
3 abc


SQL> [color=blue]SELECT[/color][color=#000000] [/color][color=maroon]col1[/color][color=silver],[/color][color=#000000] [/color][color=#000000] [/color][color=maroon]col2[/color][color=silver],[/color][color=#000000] [/color]
[color=#000000] [/color][color=maroon]([/color][color=blue]SELECT[/color][color=#000000] [/color][color=fuchsia][i]Count[/i][/color][color=maroon]([/color][color=maroon]col2[/color][color=maroon])[/color][color=#000000] [/color]
[color=#000000] [/color][color=blue]FROM[/color][color=#000000] [/color][color=maroon]test[/color][color=#000000] [/color][color=maroon]a[/color][color=#000000] [/color]
[color=#000000] [/color][color=blue]WHERE[/color][color=#000000] [/color][color=maroon]a[/color][color=silver].[/color][color=maroon]col2[/color][color=#000000] [/color][color=silver]=[/color][color=#000000] [/color][color=maroon]b[/color][color=silver].[/color][color=maroon]col2[/color][color=#000000] [/color]
[color=#000000] [/color][color=blue]GROUP[/color][color=#000000] [/color][color=blue]BY[/color][color=#000000] [/color][color=maroon]a[/color][color=silver].[/color][color=maroon]col2[/color][color=maroon])[/color][color=#000000] [/color][color=blue]AS[/color][color=#000000] [/color][color=maroon]col3[/color][color=#000000] [/color]
[color=blue]FROM[/color][color=#000000] [/color][color=maroon]test[/color][color=#000000] [/color][color=maroon]b[/color][color=silver];[/color]

COL1 COL2 COL3
---------- ---------- ----------
1 abc 2
2 xyz 1
3 abc 2
[/quote]



DB@ loo execute avvadam ledu baa

[kiraaaak]

[quote name='chandrabhai6' timestamp='1343254422' post='1302200457']
Bayya he is saying db2 so not sure analytic functions are supported
[/quote]
DB2 aaa swary ba aithe ... ORACLE anukuna

[chandrabhai6]

[quote name='arey ooo samba' timestamp='1343254545' post='1302200468']




DB@ loo execute avvadam ledu baa
[/quote]
Aliases sariga use cheyatledu neevu ani doubt

[kiss4amiss]

[quote name='arey ooo samba' timestamp='1343254545' post='1302200468']

DB@ loo execute avvadam ledu baa
[/quote]
[quote name='chandrabhai6' timestamp='1343254754' post='1302200489']

Aliases sariga use cheyatledu neevu ani doubt
[/quote]

sql and error copy paste cheyi baa...nenu oracle to try chesi paste chesaa...DB2 sandbox ledhu naa dhagara...