Calling SQL experts: count and group by

[ARYA]

landosora thread

[mysterious]

select name,  count(distinct site) from k2s group by name
loser    1
spartan    2
samaja    1
scrooge    2

[kiladi bullodu]

7 hours ago, k2s said:

Calling @loveindia, @jbourne, @Spartan, @kiladi bullodu

no sql bro

poor people

[mettastar]

6 hours ago, k2s said:

i want for all users man.. like this

name , site

scrooge, 2

spartan, 2

samaja, 1

loser, 1

 

Chinnu cheppindhi correct vuncle.. group by cheyi..

Select name, count(distinct channel) from table group by name

[k2s]

3 minutes ago, mettastar said:

Chinnu cheppindhi correct vuncle.. group by cheyi..

Select name, count(distinct channel) from table group by name

Yeah adey sesa baa.. got it

[k2s]

14 minutes ago, kiladi bullodu said:

no sql bro

poor people

[chicchara]

select count(posts), name, channel, site

group by name, channel, site

 

output will be 

posts         name      channel     site

15000      scrooge     discussion   afdb

5000      scrooge     visa   afdb

[former]

8 hours ago, k2s said:

select distinct name, count(distinct site) 

name kuda distinct kavali uncle.. 

 

Group by return DISTINCT values of group by fields. So no need of DISTINCT after SELECT keyword

[dasara_bullodu]

ses

'Select name, count(distinct site) group by name' cheste raada ?

[k2s]

4 hours ago, former said:

Group by return DISTINCT values of group by fields. So no need of DISTINCT after SELECT keyword

 

3 hours ago, dasara_bullodu said:

ses

'Select name, count(distinct site) group by name' cheste raada ?

Emo man nenu try cheyaledu

[Bhai]

13 hours ago, k2s said:

lolbob ki ardam ayindi.. answer seppadu. madyalo nuvvu thappulu vethaku..... naaku query execute ayindi with result 20 mins back ee 

 

11 hours ago, ARYA said:

landasura thread