sql question

[Naaperushiva]

9 minutes ago, Picheshwar said:

idhi deniki?

without collapsing the data...over partition will sum the numbers ..so in this case count of type c's anni prathi column ki aa number

vasthundhi...

Paina second dataset lo type C 13 vunnayi

13 ani prathi row ki vasthundhi...

It is mostly used for analytical operations....

ilaag rank over ..sum over ee functions vuntaayi chaala helpful daily job lo..

maamulga chaala subqueries raase badhulu easy gaa ayipothundhi query using over partition by

[Picheshwar]

6 minutes ago, Naaperushiva said:

without collapsing the data...over partition will sum the numbers ..so in this case count of type c's anni prathi column ki aa number

vasthundhi...

Paina second dataset lo type C 13 vunnayi

13 ani prathi row ki vasthundhi...

It is mostly used for analytical operations....

ilaag rank over ..sum over ee functions vuntaayi chaala helpful daily job lo..

maamulga chaala subqueries raase badhulu easy gaa ayipothundhi query using over partition by

Asalu requirement chadivava??

[Naaperushiva]

2 minutes ago, Picheshwar said:

Asalu requirement chadivava??

aa paina dataset choose...picchekindhi baa...

more over kevin baa python ani inthaka mundhu posts vesaadu 

so i thought baa ki complex gaa edho expecting anukunna..

same table lo anesariki confused abit

[Picheshwar]

1 minute ago, Naaperushiva said:

aa paina dataset choose...picchekindhi baa...

more over kevin baa python ani inthaka mundhu posts vesaadu 

so i thought baa ki complex gaa edho expecting anukunna

Asalu simple count(*) chalu 

[Naaperushiva]

1 minute ago, Picheshwar said:

Asalu simple count(*) chalu 

yes tharuvaatha ardham ayyindhi..

same table anesariki comfuse ayya..

paina icchina table format lone ee counts kaavali ani thought..

later realize ayya