Sql Question

[chicago]

sel
count(1)
from table1
left outer join table2
on condition echinapudu
table 1 kantay ekuva vasthunayi...
how to change that...condition lo date batti kuda undhi....

[mtkr]

count ante juz num vasthadiii..... result set em raadhu kadaaa!!!!

[mtkr]

count ) r count (1) or count(2)
eadi use chesina a condition ki match aina result count motham yentho vosthadiii either 10 r 20....

[150bryant]

clarity please

[taadu.....bongaram]

Select Count(1.*) from 1 left outer join 2 on 1.A = 2.A

[bokuboy]

[quote name='dirty kid' timestamp='1335466754' post='1301692828']
sel
count(1)
from table1
left outer join table2
on condition echinapudu
table 1 kantay ekuva vasthunayi...
how to change that...condition lo date batti kuda undhi....
[/quote]

Reg visa issue i called u...but u didn't lift the call.... call to my desk when u r free

[mtkr]

[quote name='taadu.....bongaram' timestamp='1335468701' post='1301693194']
Select Count(1.*) from 1 left outer join 2 on 1.A = 2.A
[/quote]


idi valid statement aa..!!!!
count lo ala aliasing ivvochhaaa???

[mtkr]

[quote name='bokuboy' timestamp='1335468920' post='1301693241']

Reg visa issue i called u...but u didn't lift the call.... call to my desk when u r free
[/quote]

[taadu.....bongaram]

[quote name='mtkr' timestamp='1335468986' post='1301693251']
idi valid statement aa..!!!!
count lo ala aliasing ivvochhaaa???
[/quote]

nenu ichindi tappu anukunta. * badulu primary key column iste saripotundi.

[chicago]

my qustion enti antay left join chesi nappudu first table lo unavi rvali kadha...endhuku chala chala ekuva vasthunayi....adhi ela gola adjust chesa...
by grouping the columns which are coming from second table appudu duplicates undavu kadha ..
left join chesa with table1 and table2 then the count of table 1 vachindhi...its working but i donno data correcto wrongo.....

[chicago]

[quote name='bokuboy' timestamp='1335468920' post='1301693241']

Reg visa issue i called u...but u didn't lift the call.... call to my desk when u r free
[/quote]

swary.didnt see..call you in 2 hours....

[taadu.....bongaram]

[quote name='dirty kid' timestamp='1335472418' post='1301693724']
my qustion enti antay left join chesi nappudu first table lo unavi rvali kadha...endhuku chala chala ekuva vasthunayi....adhi ela gola adjust chesa...
by grouping the columns which are coming from second table appudu duplicates undavu kadha ..
left join chesa with table1 and table2 then the count of table 1 vachindhi...its working but i donno data correcto wrongo.....
[/quote]

Select table1.* from table1 left outer join table2 on table1.A = table2.A ---- ee statement ki left sidelovi vastayi including duplicates.


Select distinct table1.* from table1 left outer join table2 on table1.A = table2.A --- ee statement use cheste duplcate records eliminate ayi vastayi.

Nuvvu Count ( * ) ani pedite 2 tables lo data vastundi anukunta. anduke more records